Lab 3 Instruction: Generating Statistics with Analysis ToolP…
Lab 3 Instruction: Generating Statistics with Analysis ToolPakOverviewIn this lab, you will use Analysis ToolPak Excel add-in to generate descriptive statistics for column SalesAmount in summary stat.xlsx. Required:Open the Excel file titled summary stat.xlsx, which contains only one column, SalesAmount.Use Analysis ToolPak à Descriptive statistics to calculate the mean, median, standard deviation, minimum, maximum, and range for SalesAmount.Answer the following questions.What is the mean for SalesAmount?