![subject](/tpl/images/cats/mat.png)
Mathematics, 30.03.2020 19:39 iancuteodora30
Demand can be estimated with experimental data, time-series data, or cross-section data. In this case, cross-section data appear in the Excel file. Soft drink consumption in cans per capita per year is related to six-pack price, income per capita, and mean temperature across the 48 contiguous states in the United States.
QUESTIONS
1. Given the data, please construct a multiple linear regression program by MS Excel. (20%)
2. Interpret each coefficient of independent variable in the soft drink demand estimated function in question 1. (20%)
3. Given your answer in question 1, please comment on whether the regression estimated function is a good fit or not. What is the interpretation of coefficient of determination (R-square)? May we use the estimated function to predict for the future demand? Explain why. (20%)
4. How many cans/capita/year on soft drink should be for a state in which 6-pack price=$1.95, Income/Capita=$23,500, and Mean Temp= 68
![ansver](/tpl/images/cats/User.png)
Answers: 1
![](/tpl/images/ask_question.png)
![](/tpl/images/ask_question_mob.png)
Other questions on the subject: Mathematics
![image](/tpl/images/cats/mat.png)
![image](/tpl/images/cats/mat.png)
Mathematics, 21.06.2019 17:30, milkshakegrande101
Which of the following tables represents exponential functions?
Answers: 1
![image](/tpl/images/cats/mat.png)
Mathematics, 21.06.2019 19:00, babygirlmiller
The weight of an object in the water is 7% of its weight out of the water. what is the weight of a 652g object in the water?
Answers: 1
![image](/tpl/images/cats/mat.png)
Mathematics, 21.06.2019 21:30, jamarengle2
Write 5(6x+4)-2(5x-2) in the form a(bx+c) where a, b and c integers and a> 1
Answers: 1
You know the right answer?
Demand can be estimated with experimental data, time-series data, or cross-section data. In this cas...
Questions in other subjects:
![Konu](/tpl/images/cats/mat.png)
![Konu](/tpl/images/cats/ap.png)
Advanced Placement (AP), 01.12.2020 03:20
![Konu](/tpl/images/cats/en.png)
![Konu](/tpl/images/cats/biologiya.png)
![Konu](/tpl/images/cats/istoriya.png)
![Konu](/tpl/images/cats/informatica.png)
Computers and Technology, 01.12.2020 03:20
![Konu](/tpl/images/cats/istoriya.png)
History, 01.12.2020 03:20
![Konu](/tpl/images/cats/en.png)
![Konu](/tpl/images/cats/mat.png)
![Konu](/tpl/images/cats/istoriya.png)
History, 01.12.2020 03:20