Question

In: Statistics and Probability

Run a linear regression using Excel’s Data Analysis regression tool. Construct the linear regression equation and...

Run a linear regression using Excel’s Data Analysis regression tool. Construct the linear regression equation and determine the predicted total sales value if the number of promotions is 6. Is there a significant relationship? Clearly explain your reasoning using the regression results.

Number of Promotions Total Sales
3 2554
2 1746
11 2755
14 1935
15 2461
4 2727
5 2231
14 2791
12 2557
4 1897
2 2022
7 2673
11 2947
11 1573
14 2980

Solutions

Expert Solution

orchestra answered 3 years ago
Next > < Previous

Related Solutions

Using the following data, conduct a linear regression analysis (by hand). In this analysis, you are...
Using the following data, conduct a linear regression analysis (by hand). In this analysis, you are testing whether SAT scores are predictive of overall college GPA. Also, write out the regression equation. How would you interpret your results? SAT Score GPA 670 1.2 720 1.8 750 2.3 845 1.9 960 3.0 1,000 3.3 1,180 3.2 1,200 3.4 1,370 2.9 1,450 3.8 1,580 4.0 1,600 3.9
Linear regression equation
Linear regression equation also find accuracy Obtain regression equation of Y on X and estimate Y when X=55 from the following 
9. The data presented in Problem 7 are analyzed using muliple linear regression analysis and the...
9. The data presented in Problem 7 are analyzed using muliple linear regression analysis and the models are shown here. In the models, the data are coded as 1= new treatment and 0= standard treatment, and age greater than 65 is coded as 1= yes and 0= no. y= 53.85- 23.54 (Treatment) y= 45.31- 19.88 (Treatment) + 14.64 (Age > 65) y= 45.51 - 20.21 (Treatment) + 14.29 (Age> 65) + .75 (Treatment X Age > 65) Patients < 65...
The data presented in Problem 7 are analyzed using multiple linear regression analysis and the models...
The data presented in Problem 7 are analyzed using multiple linear regression analysis and the models are shown here. In the models, the data are coded as 1 = new medication and 0 = standard medication, and age 65 and older is coded as 1 = yes and 0 = no. ŷ = 53.85 − 23.54 (Medication) ŷ = 45.31 − 19.88 (Medication) + 14.64 (Age 65 +) ŷ = 45.51 − 20.21 ( Medication ) + 14.29 ( Age...
a. Construct a scatterplot of the data and tell why a linear regression model is appropriate....
a. Construct a scatterplot of the data and tell why a linear regression model is appropriate. (Include this graph in your report.)   b. Run the linear regression procedure on StatCrunch and include the output in your report. c. Give the regression equation using the correct notation. d. Give the Coefficient of Determination AND interpret it.   e. Check the assumptions of the model by constructing each of the following plots and commenting on what they suggest in terms of the assumptions....
Using your calculator, run a regression analysis on the following bivariate set of data with y...
Using your calculator, run a regression analysis on the following bivariate set of data with y as the response variable. x y 71.2 23.1 90.8 122.9 88.8 82.9 57.7 18.3 71.4 8.6 60.4 25.9 60.2 -43.1 88.5 77.4 68.2 -5.9 41.1 -83 61.4 -2.5 87.1 39.4 Find the correlation coefficient and report it accurate to three decimal places. r = What proportion of the variation in y can be explained by the variation in the values of x? Report answer...
Find the equation of the regression line for the given data. Then construct a scatter plot...
Find the equation of the regression line for the given data. Then construct a scatter plot of the data and draw the regression line. (The pair of variables have a significant correlation.) Then use the regression equation to predict the value of y for each of the given x-values, if meaningful. The table below shows the heights (in feet) and the number of stories of six notable buildings in a city. Height : 772, 628, 518, 508, 496, 483, y:...
Find the equation of the regression line for the given data. Then construct a scatter plot...
Find the equation of the regression line for the given data. Then construct a scatter plot of the data and draw the regression line.​ (The pair of variables have a significant​ correlation.) Then use the regression equation to predict the value of y for each of the given​ x-values, if meaningful. The table below shows the heights​ (in feet) and the number of stories of six notable buildings in a city. Height comma x 762 621 515 508 491 480...
Find the equation of the regression line for the given data. Then construct a scatter plot...
Find the equation of the regression line for the given data. Then construct a scatter plot of the data and draw the regression line.​ (The pair of variables have a significant​ correlation.) Then use the regression equation to predict the value of y for each of the given​ x-values, if meaningful. The table below shows the heights​ (in feet) and the number of stories of six notable buildings in a city. Height comma xHeight, x 766766 620620 520520 508508 494494...
Find the equation of the regression line for the given data. Then construct a scatter plot...
Find the equation of the regression line for the given data. Then construct a scatter plot of the data and draw the regression line.​ (Each pair of variables has a significant​ correlation.) Then use the regression equation to predict the value of y for each of the given​ x-values, if meaningful. The caloric content and the sodium content​ (in milligrams) for 6 beef hot dogs are shown in the table below. font size decreased by 1 font size increased by...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT