i have stared my assignment and I now find myself stuck ! Please any help would be appreciated. i am attatching screen shots of the word doc as well as all relitive exel documentation

X X MATH215_App Assignment1 DATA.xIsx v Search (Alt+Q) mariah marsh MM AutoSave Off Comments Share File Home Insert Page Layout Formulas Data Review View Help K L M N O P H Q R S T A D E F G 1 Male Weight Female Weight 239.8 212.2 W N 140.0 108.8 185.6 156.1 161.6 131.2 208.1 179.4 417.1 396.1 125.6 93.9 LO CO 199.8 170.8 10 142.0 110.9 11 178.9 149.2 12 291.5 265.9 13 335.7 311.6 14 199.8 170.8 15 396.9 375.1 16 253.4 226.4 17 207.0 178.3 18 285.4 259.6 19 158.1 127.6 20 227.5 199.5 21 199.8 170.8 22 207.0 178.3 23 140.8 109.7 24 156.8 126.3 25 193.8 164.6 26 141.4 110.3 27 327.7 303.3 28 149.2 118.4 250 5 Height Weight Sheet1 Pulse Birth Country Percent Proficiency Education Level + + X Accessibility: Investigate We're starting the add-ins runtime, just a moment... 100% Ready 99+ 2:35 PM 67"F OLDe 10/16/2022 Mostly sunnyX X MATH215_App Assignment1 DATA.xIsx v Search (Alt+Q) mariah marsh MM AutoSave @ Off Comments Share File Home Insert Page Layout Formulas Data Review View Help P R S T A B D E F G H K L M N O Q 14 19 9.8 170.8 15 396.9 375.1 16 253.4 226.4 17 207.0 178.3 18 285.4 259.6 19 158.1 127.6 20 227.5 199.5 21 199.8 170.8 22 207.0 178.3 23 140.8 109.7 24 156.8 126.3 25 193.8 164.6 26 141.4 110.3 27 327.7 303.3 28 149.2 118.4 29 250.5 223.4 30 107.7 75.3 31 140.3 109.1 32 299.7 274.4 33 199.8 170.8 34 122.7 90.9 35 205.0 176.2 36 198.0 169.0 37 199.8 170.8 38 241.0 213.5 39 166.8 136.6 40 137.3 106.0 41 157.0 126.5 47 127.8 96.2 Height Weight Sheet1 Pulse Birth Country Percent Proficiency Education Level + Ready X Accessibility: Investigate We're starting the add-ins runtime, just a moment... + 100% 99+ 2:35 PM 67'F OLDe 10/16/2022 Mostly sunnyMM X MATH215_App Assignment1 DATA.xIsx v Search (Alt+Q) mariah marsh X AutoSave Off Comments Share File Home Insert Page Layout Formulas Data Review v View Help K L M N O P Q R S E J A B C D F G H Male-PULSE * Female-PULSE 68 76 64 72 88 88 72 60 64 72 72 68 60 80 38 64 10 76 68 11 60 68 12 96 80 13 72 76 14 56 68 15 64 72 16 60 96 17 64 72 18 84 68 19 76 72 20 84 64 21 88 80 22 72 64 23 56 80 24 68 76 25 64 76 26 60 76 27 68 80 28 60 104 20 28 Height Weight Sheet1 Pulse Birth Country Percent Proficiency Education Level + + 100% Ready Accessibility: Investigate We're starting the add-ins runtime, just a moment... 99+ 2:36 PM 67"F OLDe 10/16/2022 Mostly sunnymariah marsh X X Search (Alt+Q) MM AutoSave @ Off MATH215_App Assignment1 DATA.xIsx v Comments Share File Home Insert Page Layout Formulas Data Review v View Help P R S C D E F G H J K L M N O Q A B 13 72 70 14 56 68 15 64 72 16 60 96 17 64 72 18 84 68 19 76 72 20 84 64 21 88 80 22 72 64 23 56 80 24 68 76 25 64 76 26 60 76 27 68 30 28 60 104 29 60 88 30 56 60 31 84 76 32 72 72 33 84 72 34 88 88 35 56 80 36 64 60 37 56 72 38 56 88 39 60 88 40 64 124 41 72 64 Height Weight Sheet1 Pulse Birth Country Percent Proficiency Education Level + We're starting the add-ins runtime, just a moment... + 100% Ready Accessibility: Investigate 99+ 2:36 PM 67"F OLDe 10/16/2022 Mostly sunnyAutoSave Off mariah marsh X MATH215_App Assignment1 DATA.xIsx v Search (Alt+Q) MM X Insert Page Layout Formulas Data Review View Help Comments Share File Home D E F G H J K L M N O P R A B https://worldpopulationreview.com/country-rankings/us-immigration-by-country IN 3 Birth Country Immigrants 2018 (thousands) 4 Mexico 162 5 Cuba 76 6 China 65 7 India 60 8 Dominican Rep 57 9 Philippines 47 10 Vietnam 34 11 El Salvador 28 12 Haiti 21 13 Jamaica 20 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 20 Height Weight Sheet1 Pulse Birth Country Percent Proficiency Education Level + We're starting the add-ins runtime, just a moment... + 100% Ready XX Accessibility: Investigate 99+ 2:36 PM 67"F OLDe 10/16/2022 Mostly sunnyX AutoSave @ Off MATH215_App Assignment1 DATA.xIsx Search (Alt+Q) mariah marsh MM X File Home Insert Page Layout Formulas Data Review View Help Comments Share C D E F G H K M N O 1 https://www.nwea.org/research-data-galleries/exploring-the-educational-impacts-of-covid-19/ W Percent of students projected proficiency Fall 2020 Fall 2021 4 All Schools 51.8% 49.1% Low Poverty Schools 74.7% 73.1% 6 Low to Moderate Poverty Schools 55.7% 54.4% 7 Moderate to High Poverty Schools 42.4% 39.5% 8 High Poverty Schools 24.7% 17.6% 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 20 Height Weight Sheet1 Pulse Birth Country Percent Proficiency Education Level + We're starting the add-ins runtime, just a moment... + 100% Ready XX Accessibility: Investigate 2:36 PM 67"F Mostly sunny OLDe 99+ 10/16/2022X MATH215_App Assignment1 DATA.xIsx v Search (Alt+Q) mariah marsh MM X AutoSave @ Off Comments Share File Home Insert Page Layout Formulas Data Review View Help F G H J K L M N O P B D E https://en.wikipedia.org/wiki/Educational attainment in the United States#General attainment of degrees/diplomas W Education Level (U.S. 2018) Age 25 and over Age 25-30 High school diploma or GED 1009 92.95% Some college 61.28% 66.34% Associate and/or bachelor's degree 45.16% 46.72% Bachelor's degree 34.98% 36.98% 8 Master's and/or doctorate and/or professional degree 13.04% 9.01% 9 Doctorate and/or professional degree 3.47% 2.02% 10 Doctorate 2.03% 1.12% 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 20 Height Weight Sheet1 Pulse Birth Country Percent Proficiency Education Level + XX Accessibility: Investigate we're starting the add-ins runtime, just a moment... + 100% Ready 2:36 PM 67"F OLDe 99+ 10/16/2022 Mostly sunnyW AutoSave On MATH215_App Assignment1. docx . Saved Search (Alt+Q) mariah marsh MM X File Home Insert Draw Design Layout References Mailings Review View Help Comments Editing Share In order to complete this assignment, download the Excel file named as DATA for Application Assignment-1 from your course page in Application Assignment-1 object. There are four parts in this assignment and you will use this Excel file to answer the questions in the first three parts. Please note that there are multiple data tabs in the Excel file. Any graphs in Excel should be cut and paste on this Word document. You will turn in a single Word document, not an Excel file. Remember to title all your graphs, label the axes and use a reasonable scale. All numerical answers should be rounded to 2 digits. Part 1: Data Exploration (9 points) a) Categorize each of the following variables from the attached Excel SAMPLE data file as Quantitative (Discrete or Continuous) or Qualitative (Nominal or Ordinal). Place an X in the correct cell of the following table. A variable can ONLY be Quantitative OR Qualitative NOT both. Variable Quantitative Qualitative Discrete Continuous Nominal Ordinal Male Height X Male Weight X Female Height X Female Weight X Birth Country X Education Level X Female Pulse X Male Pulse X b) Choose one Quantitative variable from above and use the data in the Excel file for that variable to provide its descriptive statistics. If you use Excel to get the descriptive statistics, you can simply cut the output chart from Excel and paste it here. If you use your calculator (1-Var Stats), be sure to report all the descriptive stats from your calculator screen using the correct symbols. Page 1 of 4 795 words Text Predictions: On Accessibility: Investigate [ Focus + 100% 67'F 99+ 2:31 PM Mostly sunny 10/16/2022MM W AutoSave On MATH215_App Assignment1. docx . Saved Search (Alt+Q) mariah marsh X File Insert Draw Design Layout References Mailings Review View Help Comments Editing * Share Home I chose female pulse. Column1 Mean 76.3 Standard Error 1.976205 Median 74 Mode 72 Standard Deviation 12.49862 Sample Variance 156.2154 060219 Math215- Statistical Concepts Name: Franklin University Kurtosis 4.525991 Skewness 1.683896 Range 64 Minimum 60 Maximum 124 Sum 3052 Count 40 + 100% Page 1 of 4 795 words Text Predictions: On Accessibility: Investigate [ Focus OLDCHO 99+ 2:34 PM 67'F W 10/16/2022 Mostly sunnyW AutoSave On MATH215_App Assignment1. docx . Saved Search (Alt+Q) mariah marsh MM X File Home Insert Draw Design Layout References Mailings Review View Help Comments Editing * Share c) Use the same quantitative variable that you have chosen in the previous question. Find the 60th percentile and the 35th percentile of this data set for that variable. Interpret what the 60th percentile and 35th percentile mean. Note: This is sample data. 60th = 76 35th= 68 Part 2: Graphing (8 points) Answer the following questions for Part 2 using Excel Analysis Tool Pack. For the quantitative variable chosen in Part 1 above, use the sample data set for that variable to answer the following questions. a) Construct a frequency distribution, with 5-7 bins, for the variable data set you chose. Copy and paste your distribution table here. b) Construct a histogram based on this frequency distribution above. Copy and paste your histogram here. Describe the shape of the histogram and justify your answer. (Unimodal, bimodal, skewed, or approximately symmetric) c) Choose one of the qualitative variables from Part 1. Using Excel, insert a Bar Graph for the data for this variable. Make sure the percentages or frequencies show on each bar. Copy and paste your graph here. d) Based on the Bar Graph constructed in part c above, give a summary of what the data reveals. Page 2 of 4 795 words Text Predictions: On Accessibility: Investigate [ Focus + 100% 67'F 99+ 2:34 PM W Mostly sunny 10/16/2022W AutoSave On MATH215_App Assignment1.docx . Saved Search (Alt+Q) mariah marsh MM X File Home Insert Draw Design Layout References Mailings Review View Help Comments Editing * Share Part 3: Box plot Analysis (10 points) 2 060219 Math215- Statistical Concepts Name: Franklin University Choose one of the following PAIRS of variables in the Excel file: A. Male Height and Male Weight, B. Female Height and Female Weight, C. Male Height and Female Height, D. Male Weight and Female Weight E. Female Pulse and Male Pulse Highlight your selection. You will work with that pair of variables and the associated data in this part. You can use Excel or TI-84 calculator to find the numeric answers. a) List the 5-number summary for each data set (For the variables in your chosen pair). Include the variable names in the column titles below. Variable1: Variable 2: Min Q1 Median (Q2) 03 Page 2 of 4 795 words Text Predictions: On Accessibility: Investigate Focus + 100% 67'F 99+ m 2:34 PM W Mostly sunny 10/16/2022W AutoSave On MATH215_App Assignment1.docx . Saved Search (Alt+Q) mariah marsh MM X File Home Insert Draw Design Layout References Mailings Review View Help Comments Editing * Share a) List the 5-number summary for each data set (For the variables in your chosen pair). Include the variable names in the column titles below. Variable1: Variable 2: Min 01 Median (Q2) 03 Max b) Identify any outliers for each data set using the interquartile range method. Show your calculation. Include the variable names in the column titles below. Variable1: Variable2: IQR Lower Outlier Boundary Upper Outlier Boundary Outliers c) Construct a comparative box plot for the pair of variables chosen above. Describe the shape of each boxplot. d) Explain whether Empirical Rule can be used to describe the chosen data sets in Part 3a. Justify your response with a thorough explanation. Hint: Do either have outliers and/ or extreme skewness? Page 3 of 4 795 words Text Predictions: On Accessibility: Investigate [ Focus + 100% 67'F 99+ Mostly sunny OLDCHE m 2:34 PM W 10/16/2022W AutoSave On MATH215_App Assignment1.docx . Saved Search (Alt+Q) mariah marsh MM X File Home Insert Draw Design Layout References Mailings Review View Help Comments Editing * Share d) Explain whether Empirical Rule can be used to describe the chosen data sets in Part 3a. Justify your response with a thorough explanation. Hint: Do either have outliers and/or extreme skewness? Part 4: Reflection (3 points) 060219 Math215-Statistical Concepts Name: Franklin University In the past a few weeks, you have learned basic definitions of statistics, sampling types, methods to collect data, different types of statistical graphs, how to make and interpret them properly as well as misleading graphical representations. You have also learned about numerical summaries of data and how they can be used to analyze the data set. In a meaningful paragraph or two, discuss which of the topics you have learned so far struck you the most in a pleasant way and which one seemed to be the most useful in your (current or future) job field. Page 3 of 4 795 words Text Predictions: On Accessibility: Investigate [ Focus 100% 67'F 99+ m 2:35 PM W Mostly sunny 10/16/2022Search (Alt+Q) MM X AutoSave Off MATH215_App Assignment1 DATA.xIsx v mariah marsh X Data Review View Help Comments Share File Home Insert Page Layout Formulas A B D E F G H J K L M N O P R S T Male Height Female Height 71.0 65.6 W N 66.0 60.4 68.3 62.8 a UI A 67.1 61.5 69.4 63.9 80.0 74.9 LD 00 65.3 59.6 60.6 54.7 10 66.1 60.5 11 67.9 62.4 12 73.6 68.3 13 75.8 70.6 14 62.6 56.8 15 78.9 73.8 16 71.7 66.3 17 69.4 63.9 18 73.3 68.0 19 66.9 61.3 20 70.4 65.0 21 60.1 54.2 22 69.4 63.9 23 66.0 60.4 24 66.8 61.2 25 68.7 63.2 26 66.1 60.4 27 75.4 70.2 28 66.5 60.8 79 71.6 66.2 Height Weight Sheet1 Pulse Birth Country Percent Proficiency Education Level + + 100% Ready Accessibility: Investigate We're starting the add-ins runtime, just a moment... 99+ 2:35 PM 67"F OLDe 10/16/2022 Mostly sunnymariah marsh X X Search (Alt+Q) MM AutoSave @ Off MATH215_App Assignment1 DATA.xIsx v Data Review View Help Comments Share File Home Insert Page Layout Formulas A B D E F G H J K L M N O P Q R S T 16 66.3 17 69.4 63.9 18 73.3 68.0 19 66.9 61.3 20 70.4 65.0 21 60.1 54.2 22 69.4 63.9 23 66.0 60.4 24 66.8 61.2 25 68.7 63.2 26 66.1 50.4 27 75.4 70.2 28 66.5 60.8 29 71.6 66.2 30 64.4 58.7 31 66.0 60.4 32 74.0 68.7 33 61.4 55.6 34 65.1 59.5 35 69.3 63.8 36 68.9 63.4 37 69.0 63.5 38 71.1 65.7 39 67.3 61.8 40 65.9 60.2 41 66.8 61.3 42 65.4 59.7 43 Height Weight Sheet1 Pulse Birth Country Percent Proficiency Education Level + 6.We're starting the add-ins runtime, just a moment... + 100% Ready Accessibility: Investigate 99+ 2:35 PM 67"F OLDe 10/16/2022 Mostly sunny