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 to 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 Q Q Q Q IQR for the entire data using ONLY Excel Functions not using the Analysis Tool Pak AddIn d Use the Statistical measurements generated from the Analysis Toolpak AddIn 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 Filterover with a Keyboard Shortcut CtrlShiftD The
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
