Regression analysis
r 0.873
r squared 0.762
Standard error 11.547
n 7
ANOVA
SS
Regression 2.133.3333
Residual 666.6667
Total 2,800,000
Regression output p-value
Intercept 63.3333 .0005
Advertising 6.667 .0103
The local grocery store wants to predict the daily sales in dollars. The manager believes that the amount of newspaper advertising significantly affects the store sales. He randomly selects 7 days of data consisting of daily grocery store sales (in thousands of dollars) and advertising expenditures (in thousands of dollars). The Excel output given above summarizes the results of the regression model.
A. 83,333
B. 70,000
C. 68,333
D. 20,064,333
E. 20,063.33
Answer: A. 83,333
Be sure to use the number 3 instead of 3000.
r 0.873
r squared 0.762
Standard error 11.547
n 7
ANOVA
SS
Regression 2.133.3333
Residual 666.6667
Total 2,800,000
Regression output p-value
Intercept 63.3333 .0005
Advertising 6.667 .0103
The local grocery store wants to predict the daily sales in dollars. The manager believes that the amount of newspaper advertising significantly affects the store sales. He randomly selects 7 days of data consisting of daily grocery store sales (in thousands of dollars) and advertising expenditures (in thousands of dollars). The Excel output given above summarizes the results of the regression model.
If the manager decides to spend $3000 on advertising, based on the simple linear regression results given above, the estimated sales are:
A. 83,333
B. 70,000
C. 68,333
D. 20,064,333
E. 20,063.33
Answer: A. 83,333
Be sure to use the number 3 instead of 3000.
Learn More :
Correlation and Regression Analysis
- What does 1 - r^2 measure?
- Which of the following statements is not correct regarding the correlation.
- The primary purpose of a regression equation is to
- The ratio of SS(Regression) divided by the SS(Total) is also called the
- Which of the following is not based on a correlation or a regression line relating y to x?
- The percentage of variance accounted for
- The standard error is
- A regression equation is used to predict women's Weight (in pounds) from their Height (in inches). The correlation between Weight (W) and Height (H) turned out to be 0.70 . The average H was 64 inches and the average W was 119.6 pounds.
- In a regression problem, n=207 and SS(Residual)=0. Find the correlation coefficient.
- What is the formula for the correlation coefficient in terms of the cov?
- The coefficient of correlation was computed to be -0.60. This means
- We obtained the following regression equation: y(hat) = 3.5 + 2.1x.. Which of the following statements are correct?
- The coefficient of correlation.
- In a regression problem, n=52, SS(Total)=400, and r = -0.8367 Find the Standard Error.
- Find the intercept and slope of the regression line to predict Y from X.
- The correlation between X=person's weight and Y=person's height is 0.70 . What is the correlation for the same data set if we had used X=person's height and Y=person's weight?
- Compute the correlation r: Given: (E)X=40, (E)Y=20, (E)XY=300, (E)X2=580, (E)Y2=400, n=10.
- An Inverse Relationship means the trendline will have a _______ slope.
- If all the points are on the regression line, then
- A correlation of 0.02 would indicate:
- In a regression problem, the slope = 0.40 The mean and standard deviation of the X variable are both 100. The mean and standard deviation of the Y variable are both 200. Find the correlation r.
- Here is an Excel printout of a regression problem. Use this for the following 4 questions.
- What is the difference between (beta)1 and b1 ?
- R-Square values can range from _____ to ______.
- If the p-value (for the slope) on a regression printout = 0.00001 then