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

it out let someone else try.

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.

a) 1 6 11 16 21 26 32 35 36 37 38 b) -0.14 b) 24.58 c)... 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