Chapter 8 Exploring Data Analysis and Business Intelligence OSOFT EXCEL 2016 Last Updated: 12/29/17 Page 1 Independent Project 8 5 b. Restore the original values and run another Solver problem to find a selling price for a PHRE commission of 75000. Save these results as a scenario named $75,000. c. Restore the original values and run a third Solver problem to find a selling price for a net commission of $100,000. Save these results as a scenario. 7. Manage scenarios. a. Show the $50,000 scenario in the worksheet. b. Create a Scenario summary report for cells C12, C14, and C17. 8. Generate Descriptive Statistics for recent sales. a. Click the Sales Forecast sheet tab. b. Generate Descriptive Statistics for cells E4:E26 and note that the label is in the first row. c. Select the Output Range button, click the entry box, and select cell G4. d. Select the Summary statistics box and include the largest and smallest (Kth values) in the report. e. AutoFit column G (Figure 8-111). 9. Create a forecast sheet for the date and price data on the Sales Forecast sheet using a column chart. End the forecast three months from the last date in the table. Position the chart object with its top-left corner in cell E1. Size the chart object to reach cell P20. Name the generated sheet as Forecast. Mode Sale Price Sample Variance Kurtosis Skewness Mean 370593.2 Standard Error 19986.61 Median 365000 #N/A Standard Deviation 93745.5 8.79E+09 -1.23251 0.01939 Range 294100 Minimum 228900 Maximum 523000 8153050 22 Largest(1) 523000 Smallest(1) 228900 Sum Count