Details of this Paper

Homework Week 5- Magazines

Description

solution


Question

// For complete Question check the attachment// Hours New Subscriptions 1224 5357 1458 6177 1006 4795 1395 5692 1131 4312 921 3421 704 2624 1154 4087 1168 4934 803 2546 830 3591 905 4271 1435 5836 1349 5201 965 3775 985 3592 1117 4566 840 2974 1412 5673 940 3554 1090 4399 1498 6143 1240 4827 1055 5418 Provide answers for these: The attached data file (Magazines.xls) contains the hours per month spent telemarketing and the number of new subscriptions per month over a two-year period for a magazine publisher. The publisher would like to predict the number of new subscriptions based on the hours spent telemarketing. Use the data to create a scatterplot, add a trendline, request the regression line equation and the r-squared value. (You do not have to submit the scatterplot but you will need it to answer Questions 1 ? 6 below.) HINT: Make sure the explanatory variable is on the x-axis. 1. Describe the overall pattern of the relationship between hours spent telemarketing and number of new subscriptions. 2. What is the correlation between hours spent telemarketing and number of new subscriptions? [numerical answer required] 3. What is the equation for the least squares regression line? [Note: The OLI materials give the equation in the form Y = a + bx But Excel presents the equation as Y = bx + a. It doesn?t matter which way you express it as long as it is correct and you can distinguish between the intercept and the slope.] 4. If telemarketing hours increase by one hour, we would expect the number of new subscriptions to _________ by ____________. 5. Predict the number of subscriptions for a month in which there were 900 hours of telemarketing. 6. Explain why it would not be a good idea to predict the number of subscriptions for a month in which there were 1600 hours of telemarketing. 7. A researcher found that the relationship between the appraised value of a house (in thousands of dollars) and its age (in years) could be summarized by the regression equation: Appraised value = 400.8 - 2.5 * age. Interpret the value of the slope in the context of this study. 8. A medical researcher asks: What is the effect of age on blood pressure? Identify the explanatory and response variables. 9. In New York State there is a fairly strong positive correlation between principals? salaries and the reading scores of their students. (This is true.) Upon learning this, a politician recommends that principals? salaries be increased because this will cause students? reading scores to increase. Good idea? (Explain your answer.)

 

Paper#77295 | Written in 18-Jul-2015

Price : $19
SiteLock