statistics
posted by Karen .
3. The following data shows expenditures (in millions of dollars) and case (sales in millions) for seven major soft drink brands. Show a scatter diagram of the data and describe in words what it tells you. Calculate the correlation coefficient and see if it backs up the scatter diagram. Is this significant at the 5% level (ie, รก=.05)? Construct the regression equation for this data. Decide how much RC Cola would make if they spend 643.8. Do the same for Canada Dry if they spend 13.8. Is it a good idea to use this regression equation for RC and Canada Dry? Why?
Brand Spending Sales
CocaCola 131.3 1929.2
Pepsi 92.4 1384.6
Diet Coke 60.4 811.4
Sprite 55.7 541.5
Dr. Pepper 40.2 536.9
Mountain Dew 29.0 535.6
7Up 11.6 219.5
Respond to this Question
Similar Questions

statistics
Please Help! My book and instructor are no help. Please help me understand why I need to make a scatter diagram, when dealing with bivariate data, and how to find SS(x), SS(y), SS(xy), and r. I have all the formulas, but don't understand. … 
Statistics  Correlation Coefficient/Regression
'm having some difficulty with the following question: The following data shows expenditures (in millions of dollars) and case (sales in millions) for 7 major soft drink brands. Calculate the correlation coefficient. Is this significant … 
Mathstatistics
The annual sales, in millions of dollars, for 28 toy department stores is listed. 38 35 43 27 24 40 38 21 34 27 35 36 24 33 27 33 44 45 23 33 33 24 33 27 32 35 29 31 A)Calculate the mean,(u), and standard deviationof the data. Answer … 
Statistics
1. For the following exercise, complete the following by using the data sets below that provides the ages of the first seven presidents: a. Find the mean, median, and range for each of the two data sets. b. Find the standard deviation … 
Statistics
1. For the following exercise, complete the following: a. Find the mean, median, and range for each of the two data sets. b. Find the standard deviation using the rule of thumb for each of the data sets. c. Compare the two sets and … 
statistics
Given the following scatter diagram , the sample correlation coefficient r: Has a positive linear correlation Has a negative linear correlation. Has little or no correlation. Looks close to + 1.00 
Statistics
12.22 A regression was performed using data on 16 randomly selected charities in 2003. The variables were Y = expenses (millions of dollars) and X = revenue (millions of dollars). (a)Write the fitted regression equation. (b)Construct … 
statistics in psychology
11. Make up a scatter diagram with 10 dots for each of the following situations: (a) perfect positive linear correlation, (b) large but not perfect positive linear correlation, (c) small positive linear correlation, (d) large but not … 
statistics
These data were generated using the equation y = 2x + 1. A scatter diagram of the data results in five points that fall perfectly on a straight line. x 0 1 2 3 4 y 1 3 5 7 9 (a) Find the correlation coefficient. 
Statistics
The scatter diagram shows: a. The frequency with which each value occurs in the data. b The values of a variable designed in comparison with the values of a second variable. c. The mean data sets. d. The …