• Evaluate the mean and median
• Interpret the mean and median in plain non-technical terms
• Use the Excel = AVERAGE function to find the mean
• Use the Excel = MEDIAN function to find the median
• For each column containing quantitative data:
• Evaluate the standard deviation and range
• Interpret the standard deviation and range in plain non-technical terms
• Use the Excel = STDEV. S function to find the standard deviation
• For range( maximum value minus the minimum value), find the maximum value using the Excel = MAX function and find the minimum value using the Excel ' s = MIN function
Company Type Total Revenues AFLAC 6 7251 Albertson ' s 4 14690 Allstate 6 20106 Amerada Hess 7 8340 American General 6 3362 American Stores 4 19139 Amoco 7 36287 Arco Chemical 2 3995 Ashland 7 14319 Atlantic Richfield 7 19272 Bausch & Lomb 5 1916 Baxter International 5 6138