Answered step by step
Verified Expert Solution
Question
1 Approved Answer
02 10 Points Open the file USTobacco MostRecent.xlsx which contains data on the total amount of tobacco produced in the US over the years. (If
02 10 Points Open the file USTobacco MostRecent.xlsx which contains data on the total amount of tobacco produced in the US over the years. (If you have trouble downloading the file from the link, right click and choose Save as..) 02.1 2 Points Make an XY scatterplot of the data including the trendline, linear function, and R2 value. Note that Excel will, in most cases, put a legend on your graph by default. When there is only one data series (as here), you don't need a legend, and it really should be removed. Select your chart in Excel, rightclick on it and choose Save as Picture. Attach the saved picture in the field below. (You can also simply take a screenshot if that is easier.) Ia Please select filels) Select file(s) Save Answer 02.2 1 Point Interpret the rate of change in terms of the context: Over the period from 1990 to 2021, for every Enter your answer here on average there is a Enter your answer here Enter your answer here in the billions of pounds of tobacco produced in the US. 02.3 2 Points Using your linear model (equation method) and the extended trendline method, predict how many billions of lbs of tobacco will be produced in the US in 2022. When using equation method, use slope and intercept functions to calculate the most accurate slope and intercept, and using cell references to those, calculate the prediction for 2020. Show both results below by showing your work in the box below, and attaching the image of your extended trendline graph below. Enter your answer here Q Please select fi|e(s) Select file(s) 02.4 1 Point How much faith do you have in your prediction? Write a short paragraph using the language and the five guidelines we learned in class. Enter your answer here 02.5 2 Points Use your model to estimate how much tobacco was produced in the US in 1940. Show your work. Enter your answer here Do you have faith in this prediction? Discuss in detail using the 5 guidelines. Enter your answer here 02.6 2 Points Use your model to estimate when the US will produce zero pounds of tobacco. Show your work. Enter your answer here Write a short paragraph using the language and the five guidelines we learned in class. Enter your answer here
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started