Cashback Offer (8th - 31st July, 2020). Get Flat 10% Cashback credited in your account on minimum transaction of $80. Post Your Question

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

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
$ 5.00
Homework Assignment
  • This Solution has been Purchased 1 time
  • Average Rating for this solution is A+
  • Submitted On 02 Dec, 2019 07:23:23
Solution posted by
QUESTION 1 By using scatter plot, show if there is a relationship between alcohol content an...
Buy now to view full solution.
Other Related Questions
User Image
User Image
User Image
Only 45 characters allowed.

$ 629.35