Question Details Normal
$ 5.00
Homework Assignment
  • From Mathematics, Statistics
  • Due on 08 Dec, 2019 01:00:00
  • Asked On 02 Dec, 2019 12:11:44
  • Due date has already passed, but you can still post solutions.
Question posted by
request

Mr. Drunk was interested to know if there is a relationship between the alcohol content and the number of calories in 12-ounce beer (whether if alcohol determines the amount of calories in a beer). To determine if there is one, a random sample was taken of beer’s alcohol content and calories (calories and alcohol content data file). 

  1. By using scatter plot, show if there is a relationship between alcohol content and the calories for the above beer brands. Discuss your outcomes 

    (Note: you should determine your x-axis and y-axis variable respectively. Y axis represent, dependent variable while x axis represents independent variable)

  2. Formulate regression equation to show linear relationship between the two variables. 

    (Remember your regression equation should take the form Y = fn (X). Thus, Y = a + bX + e)  

  3. Use excel to run regression analysis
    (Use Excel’s ToolPak, Regression Analysis)
  4. Interpret the regression outcomes to validate your regression equation, i.e.,
    • Multiple R (Correlation of the regression equation),
    • R squared, as well as
    • Adjusted R squared.
  5. Rewrite your regression model to include coefficients from your regression analysis output and then answer the following question
  6. What is the number of calories when the alcohol content is 6.50%
Available solutions
$ 7.00
Assignment solution
  • This solution has not purchased yet.
  • Submitted On 02 Dec, 2019 01:12:07
Solution posted by
solution
Adjusted R squared value tells us the percent of variation in the respons...
Buy now to view full solution.
Other Related Questions
User Image
drehe...
User Image
cstel...
User Image
drehe...
closebutton
Only 45 characters allowed.
closebutton

$ 629.35