Open the data file in Excel and “clean up” the data. This involves making any data updates for… 1 answer below »

Open the data file in Excel and “clean up” the data. This involves making any data updates for entries like 61 inches changed to 61 in the data file. Removing units or extraneous information is an important first step! 2. You can save the file as an Excel file and then open in Minitab ** 3. Choose a quantitative variable from the data file and do the following: a) Describe the variable and variable type. b) Calculate the descriptive statistics including the mean, median, mode, variance, standard deviation, Q1, Q3, minimum, maximum, and IQR. c) Use an appropriate graphical display to show the data. Make sure to label your axes and title your graph. Note: If using a histogram, you MUST use the cut point feature to display the intervals. d) Summarize in your own words the shape, spread, central tendency and if there are any outliers. Include any thoughts on the graphical display and descriptive statistics that could be used to make generalizations about the students in the ST 260 class. 4. Choose a categorical variable from the data file and do the following: a) Describe the variable and variable type. b) Create a summary table showing the counts of each group/category, mentioning the mode. This is called a pivot table in Excel. c) Use an appropriate graphical display to show the data. Make sure to title your graph. d) Summarize in your own words the categorical variable information. Include any thoughts on the graphical display and summary information that could be used to make generalizations about the students in the ST 260 class.