Ex5 Create A Scatter Chart Using The Table That Begins In B2 Move The New Chart To Begin At Cell E9 Add A Trendli 1 (28.55 KiB) Viewed 35 times
Ex5 Create A Scatter Chart Using The Table That Begins In B2 Move The New Chart To Begin At Cell E9 Add A Trendli 2 (39.31 KiB) Viewed 35 times
EX5 • Create a Scatter Chart using the table that begins in B2. • Move the new chart to begin at cell E9 • Add a Trendline, Linear Equation, and R-squared value. • Calculate the Variance, Intercept, Slope, R-square, and Standard Error in E4:14 Calculate the Forecast (FORCAST.LINEAR) for E7 in F7. Do a check for the forecast in G7 using E7, G4, and F4. Use 14 to calculate the high and low for the forecast in H7 and 17. Format F7:17 with accounting number format. .
Variance Intercept Slope R-square Standard Error Forecast Check High Low Units 25000 Doofenshmirtz Air Fresheners Units Produced Profit 1000 $250.00 1500 $500.00 2000 $750.00 2500 $1,000.00 3000 $1,250.00 3500 $1,500.00 4000 $1,750.00 4500 $2,000.00 5000 $2,250.00 5500 $2,500.00 6000 $2,750.00 6500 $3,000.00 7000 $3,250.00 7500 $3,500.00 8000 $3,750.00 8500 $4,000.00 9000 $4,250.00 9500 $4,500.00 10000 $5,000.00
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!