I am desperate need of help on this one. I posted this one earlier and no one se
ID: 403499 • Letter: I
Question
I am desperate need of help on this one. I posted this one earlier and no one seems to want to take a crack at it. I have increased the points. Full credit goes to the individual that responds first with the correct answer. Also...I need an Excel Spreadsheet to show work. Please email to jenniferklatt@ymail.com. Please make sure to highlight all answers clearly. Thanks -Cola Consumption
The following data were taken from a study relating the Days High Temperature to the Average Amount of Cola Consumed (per capita) in a small mid-western town.
Observation Days High Temperature Average Ounces of Cola Consumed 1 81 77 2 77 84 3 74 82 4 56 65 5 87 90 6 101 122 7 76 94 8 62 74 9 104 119 10 91 95 11 75 90 12 70 85 13 56 50 14 62 72 15 60 58 16 97 118 17 101 99 18 73 72 19 66 92 20 60 81
Given the 20 Observations above, use a Regression Tool like DATA ANALYSIS in Excel and find each of the following:
Slope of Regression Equation =
Hint: Value should be between 0.56 and 1.86
Y Intercept for the Regression Equation =
Correlation Coefficient = (Round to Nearest 100th, e.g., 0.9762123 = 0.98)
Coefficient of Determination =
(Round to Nearest 100th, e.g., 0.95299 = 0.95)
Using your Regression Equation, Predict Cola Consuption when the High Temperature = 23:
ColaConsumption (23)=
Unless otherwise stated, Round all answers to the nearest %u201C100th%u201D, e.g., 16.41234 = 16.41 Enter whole numbers like 24 as 24.00
I am desperate need of help on this one. I posted this one earlier and no one seems to want to take a crack at it. I have increased the points. Full credit goes to the individual that responds first with the correct answer. Also...I need an Excel Spreadsheet to show work. Please email to jenniferklatt@ymail.com. Please make sure to highlight all answers clearly. Thanks -
Cola Consumption
The following data were taken from a study relating the Days High Temperature to the Average Amount of Cola Consumed (per capita) in a small mid-western town.
Observation Days High Temperature Average Ounces of Cola Consumed 1 81 77 2 77 84 3 74 82 4 56 65 5 87 90 6 101 122 7 76 94 8 62 74 9 104 119 10 91 95 11 75 90 12 70 85 13 56 50 14 62 72 15 60 58 16 97 118 17 101 99 18 73 72 19 66 92 20 60 81
Given the 20 Observations above, use a Regression Tool like DATA ANALYSIS in Excel and find each of the following:
Slope of Regression Equation =
Observation Days High Temperature Average Ounces of Cola Consumed 1 81 77 2 77 84 3 74 82 4 56 65 5 87 90 6 101 122 7 76 94 8 62 74 9 104 119 10 91 95 11 75 90 12 70 85 13 56 50 14 62 72 15 60 58 16 97 118 17 101 99 18 73 72 19 66 92 20 60 81 Hint: Value should be between 0.56 and 1.86
Y Intercept for the Regression Equation =
Y Intercept for the Regression Equation =
Correlation Coefficient =
Correlation Coefficient = (Round to Nearest 100th, e.g., 0.9762123 = 0.98) (Round to Nearest 100th, e.g., 0.9762123 = 0.98)
Coefficient of Determination =
(Round to Nearest 100th, e.g., 0.95299 = 0.95)
Using your Regression Equation, Predict Cola Consuption when the High Temperature = 23:
ColaConsumption (23)=
Unless otherwise stated, Round all answers to the nearest %u201C100th%u201D, e.g., 16.41234 = 16.41 Enter whole numbers like 24 as 24.00
Coefficient of Determination =
(Round to Nearest 100th, e.g., 0.95299 = 0.95)
Using your Regression Equation, Predict Cola Consuption when the High Temperature = 23:
ColaConsumption (23)=
Unless otherwise stated, Round all answers to the nearest %u201C100th%u201D, e.g., 16.41234 = 16.41 Enter whole numbers like 24 as 24.00
Observation Days High Temperature Average Ounces of Cola Consumed 1 81 77 2 77 84 3 74 82 4 56 65 5 87 90 6 101 122 7 76 94 8 62 74 9 104 119 10 91 95 11 75 90 12 70 85 13 56 50 14 62 72 15 60 58 16 97 118 17 101 99 18 73 72 19 66 92 20 60 81
Explanation / Answer
Given the 20 Observations above, use a Regression Tool like DATA ANALYSIS in Excel and find each of the following:
Slope of Regression Equation =
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.