Question

xi 135 110 130 145 175 160 120 yi 145 100 125 120 135 130 110...

xi

135 110 130 145 175 160 120

yi

145 100 125 120 135 130 110

I need the standardized residual for this data, with my answer rounded to 2 decimal points

I did data analysis in excel, I ran a regression using standardized residuals, but only "observation 3= 0.49" is coming out correctly. What am I not understanding about this concept, I followed the instructions on excel and the video.

Homework Answers

Answer #1
OVERALL FIT
Multiple R 0.663031
R Square 0.43961
Adjusted R Square 0.327532
Standard Error 12.46227
Observations 7
ANOVA Alpha 0.05
df SS MS F p-value sig
Regression 1 609.1736 609.1736 3.922355 0.104512 no
Residual 5 776.5407 155.3081
Total 6 1385.714
coeff std err t stat p-value lower upper
Intercept 61.5407 31.67305 1.942999 0.109649 -19.8775 142.9589
xi 0.445349 0.224868 1.980494 0.104512 -0.13269 1.023389

standardized residuals= residual/std error

Obs xi yi Pred Y Residual SResidual
1 135 145 121.6628 23.34 1.87
2 110 100 110.5291 -10.53 -0.84
3 130 125 119.436 5.56 0.45
4 145 120 126.1163 -6.12 -0.49
5 175 135 139.4767 -4.48 -0.36
6 160 130 132.7965 -2.80 -0.22
7 120 110 114.9826 -4.98 -0.40
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Consider the following data for two variables, x and y. xi 135 110 130 145 175...
Consider the following data for two variables, x and y. xi 135 110 130 145 175 160 120 yi 145 105 120 115 130 130 110 (a) Compute the standardized residuals for these data. (Round your answers to two decimal places.) xi yi Standardized Residuals 135 145 110 105 130 120 145 115 175 130 160 130 120 110 Do the data include any outliers? Explain. (Round your answers to two decimal places.) The standardized residual with the largest absolute...
A statistical program is recommended. Consider the following data for two variables, x and y. xi...
A statistical program is recommended. Consider the following data for two variables, x and y. xi 135 110 130 145 175 160 120 yi 145 105 120 115 130 130 110 (a) Compute the standardized residuals for these data. (Round your answers to two decimal places.) xi yi Standardized Residuals 135 145 110 105 130 120 145 115 175 130 160 130 120 110 Do the data include any outliers? Explain. (Round your answers to two decimal places.) The standardized...
A physiological experiment was concluded to study the effect of various factors on a pulse rate....
A physiological experiment was concluded to study the effect of various factors on a pulse rate. The participants took their own pulse. They then were asked to flip a coin. If their coin came up head, they were to run in place for 1 minute. Then everyone took their own pulse again. The dataset pulse.txt, available from Moodle, contains the following variables: ROW- id numbers, from 1 to 92; PULSE1- first pulse rate; PULSE2- second pulse rate; RAN-1=ran in place,...
Use the dependent variable (labeled Y) and the independent variables (labeled X1, X2, and X3) in...
Use the dependent variable (labeled Y) and the independent variables (labeled X1, X2, and X3) in the data file. Use Excel to perform the regression and correlation analysis to answer the following. Generate a scatterplot for the specified dependent variable (Y) and the X1 independent variable, including the graph of the "best fit" line. Interpret. Determine the equation of the "best fit" line, which describes the relationship between the dependent variable and the selected independent variable. Determine the coefficient of...
4) In order to determine the best-selling style of tennis rackets that are sold in State...
4) In order to determine the best-selling style of tennis rackets that are sold in State College, you have collected data from all sporting goods stores in town. A tennis racket is classified by both its head size and grip size. The Excel sheet “Sales Data Tennis Rackets” in Module 3 contains the data you collected for sales of tennis rackets. Each entry in the Excel sheet represents the sale of one tennis racket. You will have to separate your...
Researchers in a 2015 study by Flannery et al. sought to estimate the effectiveness of the...
Researchers in a 2015 study by Flannery et al. sought to estimate the effectiveness of the seasonal influenza vaccine in preventing acute respiratory infection (ARI). A total of 507 subjects from Texas who showed symptoms of ARI were recruited for this study. The data provided show the result of each subject's test for influenza. Click to download the data in your preferred format.    CrunchIt!    CSV    Excel    JMP    Mac-Text    Minitab    PC-Text    R   ...
Bivariate Data & Probability After completing the calculation by hand in Q1 you can use Excel...
Bivariate Data & Probability After completing the calculation by hand in Q1 you can use Excel to check your answers before submitting. Q2 assesses your general understanding of probability and linear associations using Excel to analyse a large dataset. Question 1       Covariance and Correlation The table below shows a set of sample bivariate data. Calculate the covariance and correlation coefficient by completing the below table. Show all working. X Y (X - ) (Y - ) (X - )(Y -...
What tools could AA leaders have used to increase their awareness of internal and external issues?...
What tools could AA leaders have used to increase their awareness of internal and external issues? ???ALASKA AIRLINES: NAVIGATING CHANGE In the autumn of 2007, Alaska Airlines executives adjourned at the end of a long and stressful day in the midst of a multi-day strategic planning session. Most headed outside to relax, unwind and enjoy a bonfire on the shore of Semiahmoo Spit, outside the meeting venue in Blaine, a seaport town in northwest Washington state. Meanwhile, several members of...