We have launched another newest and most powerful study guides and notes selling website DocMerit. Now Earn more while you Learn Join now

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
No solution has been posted yet.Be first to post the solution!
Other Related Questions
User Image
User Image
User Image
Only 45 characters allowed.

$ 629.35