Question: . Illinois Temp contains temperature data for Northern Illinois from 1 8 9 5 to 1 9 9 8 a . Compute the Average Temperature

.Illinois Temp contains temperature data for Northern Illinois from 1895 to 1998 a. Compute the Average Temperature for each year (Fill Column N). b. Convert the Data available into a Table and choose a Design of your choice. c. Obtain the Mean, Median, Standard Deviation, Variance, Quartiles (Q1, Q2, Q3, Q4), IQR for the entire data (1895-1998), using ONLY Excel Functions (not using the Analysis Tool Pak Add-In) d. Use the Statistical measurements generated from the Analysis Toolpak (Add-In) and compare the values obtained in (c). Comment on your findings. e. Identify the Outliers in the data, if any. Comment on your findings. f. BONUS: Record a Macro titled Filter_over25 with a Keyboard Shortcut Ctrl+Shift+D. The

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!