[Solved] CS4650 Project 1-Excel

All questions refer to the Excel Sheet(Questions.xlsx)

Screen Capture results and save in a PDF or DOC file. Submit assignment on Blackboard.

All screen shots should be upright in orientation and the questions should be answered in order.

NOTE: You are encouraged to HELP each other on SLACK! Do not share screen shots but, assist each other on how to complete this assignment. Ask each other for help in the Questions and Answers channel.

1a) Create a pie chart of the sales by product columns. 1b) Create a bar chart of sales by employee.

2) Filter the sales data to show only sales for the South region and then sort the sales from highest to lowest.

Save the automotive data as a .csv file. Comma Separated File.

4) Calculate the Mean, Median, Standard Deviation and Variance of the data values provided.

Use Excels conditional formatting to highlight the top 10% of values.

Determine the min, max, fourth largest and fifth largest values.

Calculate the equation of the line that best matches the data.

Use Excels What-If Analysis to determine the price change you would need to make a profit of $1,000.

• Forecast sales with a 90% confidence interval.

• Create a Pivot Table that shows sales by salesperson per month