A A B c L L . 6 Years since 1980 allons per person 7 1980 24.3 S 1985 23.8 9 1990 23.9 10 1995 21.8 11 2000 21.7 12 2005 21.3 13 2011 1.8 14 2014...
View the step-by-step solution to:

Question

Beer1.jpg

Please help me figure this out. If you can't figure

it out let someone else try.

Beer1.jpg

A A B c L L . 6 Years since 1980 allons per person 7 1980 24.3
S 1985 23.8
9 1990 23.9
10 1995 21.8
11 2000 21.7
12 2005 21.3
13 2011 1.8.8
14 2014 20.0
15 2015 19.9
16 2016 19.8
17 2017 19.8
13 19 21 217 a; 23 2L as 21 27 b.) INTERCEPT: d.) 2020 Estimate gallons per person per year
e.) Pints: p nus per person pervear
f.) E b.) Compute the slope of the linear trendline using the SLOPE function, years since 1980 as inputs, and
gallons per person as outputs. Format to 2 decimal places. Compute the yeintercept using the INTERCEPT function, years since 1980 as inputs, and gallons per
person as outputs. Format to 2 decimal places. an estimate of the U 5 beer consump d.) Use the slope and yeintercept to estimate the US. beer consumption per capita in 2020. Format to
one decimal place. 2.] Convert the slope to pints per person per year. A gallon has 128 ounces and a pint has 16 ounces.
Format to 1 decimal place. n per capita in what year? f.) Which of the following sentences provides a plausible explanation for the drop in annual beer
I. The population is increasing so all rates per person must go down.
ii. The population is aging, meaning a higher percentage of the population isover 65, and the elderly
drink less beer.

Top Answer

a) 1 6 11 16 21 26 32 35 36 37 38 b) -0.14 b) 24.58 c)... View the full answer

1.PNG

Sign up to view the full answer

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question