Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Add trendlines to the chart to forecast exponential growth for the next 40 years. Click the Chart Elements button that appears near the upper right
Add trendlines to the chart to forecast exponential growth for the next 40 years. Click the Chart Elements button that appears near the upper right corner of the chart. Point to Trendline, click the arrow that appears, and click More Options. In the Add Trendline dialog, click OK. (Northeast should be selected by default.) In the Format Trendline task pane, click the Exponential radio button. In the Forecast section, type 4 in the Forward box. Click the Fill & Line button near the top of the task pane. Click in the Width box and change the value to 3. Click the End Arrow type box and select Open Arrow (the third option in the top row). Right-click any data point in the Midwest series and select Add Trendline.... Apply the same formatting options as you applied to the Northeast trendline: exponential, forecasting forward for 4 periods, 3 pt width, and arrow type End Open Arrow. Follow the same steps to add a trendline to each of the other data series using the same formatting options (exponential, forecasting forward for 4 periods, 3 pt width, and arrow type End Open Arrow). Save and close the workbook. Upload and save your project
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