Can you help me answer this mathematical questions related to data management? Thank you so much!!!

IS MMW Module 7 Post Task 2nd SE X _> Course Modules: Mathematics in X + X C A docs.google.com/forms/d/e/1FAlpQLSdHppqOseOlSezUz4Zh4kog8tEmXGBkFTjInNY4-jipKSgsfg/viewform Q Identify if the following shows characteristics of descriptive statistics or 10 points inferential statistics. SITUATION: The last four semesters an instructor taught Intermediate Algebra, the following numbers of people passed the class: 17, 19, 4, 20. * Descriptive Inferential The last four semesters the instructor taught Intermediate Algebra, no O O more than 20 people passed the class The next time the instructor teaches Intermediate Algebra, we can expect O O approximately 15 people to pass the class. The last four semesters the instructor taught Intermediate Algebra, an O O average of 15 people passed the class Only 5 people passed one semester because the instructor was in a bad mood O O the entire semester. This instructor will never pass more than 20 people in an Intermediate Algebra O O Type here to search 7:50 pm O WE x 1 04/06/2021IS MMW Module 7 Post Task 2nd SE X > Course Modules: Mathematics in X + X C A docs.google.com/forms/d/e/1FAlpOLSdHppqOseOlSezUz4Zh4kog8tEmXGBkFTj InNY4-jipKSgsfg/viewform Q class: 17, 19, 4, 20. Descriptive Inferential The last four semesters the instructor taught Intermediate Algebra, no O O more than 20 people passed the class. The next time the instructor teaches Intermediate Algebra, we can expect O O approximately 15 people to pass the class. The last four semesters the instructor taught Intermediate Algebra, an O O average of 15 people passed the class Only 5 people passed one semester because the instructor was in a bad mood O O the entire semester. This instructor will never pass more than 20 people in an Intermediate Algebra O O class. Identify if the following shows qualitative, discrete or continuous 10 points Type here to search O WE m x ] 7:50 pm 04/06/2021IS MMW Module 7 Post Task 2nd SE X Course Modules: Mathematics in X + X C A docs.google.com/forms/d/e/1FAlpQLSdHppqOseOlSezUz4Zh4kog8tEmXGBkFTjInNY4-jipKSgsfg/viewform Q Identify if the following shows qualitative, discrete or continuous 10 points variables. [Types of Variables] * Qualitative Discrete Continuous The rock sample contains 78.1% O O O limestone. The alloy is made up of copper and zinc. O O O The temperature of the liquid rose to 98 O O O K. The weighing boat contains 6.231 grams of sodium O O O bicarbonate The piece of magnesium ribbon is silver in color with O O O blackened edges. Identify if the following shows nominal, ordinal, interval or ratio level. 10 points [Levels of Measurement] * Type here to search O WE x 1 7:50 pm 04/06/2021IS MMW Module 7 Post Task 2nd SE X > Course Modules: Mathematics in X + X C A docs.google.com/forms/d/e/1FAlpQLSdHppqOseOlSezUz4Zh4kog8tEmXGBkFTjInNY4-jlpKSgsfg/viewform Q blackened eyes . Identify if the following shows nominal, ordinal, interval or ratio level. 10 points [Levels of Measurement] * Nominal Ordinal Interval Ratio Temperature in Manila O O O O Time it reaches for the student to O O O O go home Salaries of each household in O O O O Manila Student's registration O O O O number in school Qualitative ratings of school O O O O in Manila Identify if the following shows simple random, systematic, stratified or 15 points cluster. [Sampling Techniques] * Type here to search O WE 7:50 pm 04/06/2021IS MMW Module 7 Post Task 2nd SE X (> Course Modules: Mathematics in X + X C A docs.google.com/forms/d/e/1FAlpQLSdHppqOseOlSezUz4Zh4kog8tEmXGBkFTjInNY4-jipKSgsfg/viewform Q Identify if the following shows simple random, systematic, stratified or 15 points cluster. [Sampling Techniques] * Simple Random Systematic Stratified Cluster An auto analyst is conducting a satisfaction survey, sampling from a list of 10,000 new car buyers. The list includes 2500 Ford buyers, 2500 GM buyers, 2500 Honda O O O O buyers and 2500 Toyota buyers. The analyst selects a sample of 400 cur buyers, by randomly selecting 100 buyers from each brand. In a large school district, all teachers from two buildings are interviewed to determine whether they O O O O believe the students have Type here to search O WE x 1 7:50 pm 04/06/2021EE MMW Module 7 F'ost Tesla: End (3 H docsgooglecom randomly selecting 100 buyers from each brand. In a large school district, all teachers from two buildings are interviewed to de1ermihe whether they 0 O O O believe the students have less homework to do now than in previous years Mail carriers of a large city are divided into four groups according to gender (male or female) and according to whether they walk or ride on their routes. Then 0 O O O 'l are selected from each group and interviewed to determine whether they have been bitten I by a dog in the last year. ' IS MMW Module 7 Post Task 2nd SE X (> Course Modules: Mathematics in X X C A docs.google.com/forms/d/e/1FAlpQLSdHppqOseOlSezUz4Zh4kog8tEmXGBkFTjInNY4-jipKSgsfg/viewform Q to gender (male or female) and according to whether they walk or ride on their routes. Then O O O O 10 are selected from each group and interviewed to determine whether they have been bitten by a dog in the last year. A high school counselor uses a computer to generate 50 random numbers and then picks O O O O students who names correspond to the numbers. Every 100th hamburger manufactured is checked to O O O O determine its fat content. Type here to search 7:50 pm O WE x 1 04/06/2021IS MMW Module 7 Post Task 2nd SE X Course Modules: Mathematics in X + X C A docs.google.com/forms/d/e/1FAlpOLSdHppqOseOlSezUz4Zh4kog8tEmXGBkFTjInNY4-jipKSgsfg/viewform Q PROBLEM 1: Round off your final answer to 2 decimal places. Type NONE if there is no possible answer. V. Compute for the mean, median, mode, range, standard deviation and variance of each of the trust ratings of the 2 presidents. Determine who among them is better in each computation. (20 points President Rating Rating Rating Rating Rating Rating 2 3 4 5 6 Estrada 74 61 53 49 53 50 Aquino 79 74 71 79 71 74 Based on Problem 1, what is the MEAN of Estrada? * 2 points Your answer Based on Problem 1, what is the MEAN of Aquino? * 2 points Your answer Based on Problem 1, what is the MEDIAN of Estrada? * 2 points Type here to search O WE m x ] 7:50 pm 04/06/2021IS MMW Module 7 Post Task 2nd SE X Course Modules: Mathematics in X + X C A docs.google.com/forms/d/e/1FAlpQLSdHppqOseOlSezUz4Zh4kog8tEmXGBkFTjInNY4-jipKSgsfg/viewform Q Based on Problem 1, what is the MEAN of Aquino? * 2 points Your answer Based on Problem 1, what is the MEDIAN of Estrada? * 2 points Your answer Based on Problem 1, what is the MEDIAN of Aquino? * 2 points Your answer Based on Problem 1, what is the MODE of Estrada? * 2 points Your answer Based on Problem 1, what is the MODE of Aquino? * 2 points Type here to search O WE x ] 7:50 pm 04/06/2021IS MMW Module 7 Post Task 2nd SE X Course Modules: Mathematics in X + X C A docs.google.com/forms/d/e/1FAlpQLSdHppqOseOlSezUz4Zh4kog8tEmXGBkFTj InNY4-jipKSgsfg/viewform Q Your answer Based on Problem 1, what is the MODE of Aquino? * 2 points Your answer Based on Problem 1, what is the RANGE of Estrada? * 2 points Your answer Based on Problem 1, what is the RANGE of Aquino? * 2 points Your answer Based on Problem 1, what is the VARIANCE (SAMPLE) of Estrada? * 2 points Your answer O x ] 7:50 pm Type here to search ED 04/06/2021IS MMW Module 7 Post Task 2nd SE X Course Modules: Mathematics in X + X C A docs.google.com/forms/d/e/1FAlpQLSdHppqOseOlSezUz4Zh4kog8tEmXGBkFTjInNY4-jipKSgsfg/viewform Q Based on Problem 1, what is the VARIANCE (SAMPLE) of Aquino? * 2 points Your answer Based on Problem 1, what is the STANDARD DEVIATION (SAMPLE) of 2 points Estrada?* Your answer Based on Problem 1, what is the STANDARD DEVIATION (SAMPLE) of 2 points Aquino? * Your answer PROBLEM 2: General Weighted Average VI. Compute for the general weighted average of this student. (5) points Subject Units Grade EDSC 121 3.0 1.75 EDTECH 101 3.0 1.00 Type here to search O M m 7:50 pm 04/06/2021IS MMW Module 7 Post Task 2nd SE X (> Course Modules: Mathematics in X + X C A docs.google.com/forms/d/e/1FAlpQLSdHppqOseOlSezUz4Zh4kog8tEmXGBkFTj InNY4-jipKSgsfg/viewform Q PROBLEM 2: General Weighted Average VI. Compute for the general weighted average of this student. (5 points Subject Units Grade EDSC 121 3.0 1.75 EDTECH 101 3.0 1.00 Math 121.1 3.0 2.00 Physics 72 4.0 3.00 Physics 72.1 1.0 2.25 Stat 101 3.0 1.25 Based on Problem 2, what is the General Weighted Average of this 3 points student? Round off to 2 decimal places. * Your answer PROBLEM 3: Answer this part using MICROSOFT EXCEL. Type your answers inside the Excel file. Upload the file next to this question. V. Identify what test is to be used on the following data. Write the null and alternative hypothesis, if one-tail and two-tail, decision rule if to reject or do not reject null hypothesis. For linear regression and correlation, identify also its direction and strength. [15 points each] 1. Mr. Sanchez wants to know if the mean of his set of students from Mathematics majors is greater than that of the non-Mathematics majors with regards to the subject Mathematics in the Modern World. Consider the following data is at alpha is equal to 0.10. MATHEMATICS MAJORS 87 89 86 89 87 88 90 98 97 98 96 93 94 92 91 97 91 89 86 Type here to search O WE 19 7:50 pm 04/06/2021IS MMW Module 7 Post Task 2nd SE X Course Modules: Mathematics in X + X C A docs.google.com/forms/d/e/1FAlpQLSdHppqOseOlSezUz4Zh4kog8tEmXGBkFTjInNY4-jlpKSgsfg/viewform Q PROBLEM 3: Answer this part using MICROSOFT EXCEL. Type your answers inside the Excel file. Upload the file next to this question. V. Identify what test is to be used on the following data. Write the null and alternative hypothesis, if one-tail and two-tail, decision rule if to reject or do not reject null hypothesis. For linear regression and correlation, identify also its direction and strength. [15 points each] 1. Mr. Sanchez wants to know if the mean of his set of students from Mathematics majors is greater than that of the non-Mathematics majors with regards to the subject Mathematics in the Modern World. Consider the following data is at alpha is equal to 0.10. MATHEMATICS MAJORS 87 89 86 89 87 88 90 98 97 98 96 93 94 92 95 91 97 91 89 86 NON MATHEMATICS MAJORS 79 83 92 84 83 81 80 89 96 91 77 79 80 84 96 94 93 89 86 83 .The grades of 10 college students on their midterm examination (X) and on their final examination (Y) are given below. Determine if there is a linear relationship existing on the study. The following data is at alpha is equal to 0.01. X 78 72 50 99 68 84 80 55 99 70 Y 86 56 65 99 70 94 72 81 96 68 Upload your EXCEL FILE here that will answer the PROBLEM 3 above. * 28 points 1. Add file Upload your solutions here. 1 Add file Type here to search O ED 7:50 pm 04/06/2021