Problems need to include all required steps and answer(s) for full credit. All answers need to be reduced to lowest terms where possible. If the answer is in %, show two decimal places.Answer the following problems showing your work and explaining (or analyzing) your results. Submit your work in a typed Microsoft Word document.Below are excel functions, which you can use to solve for measures of central tendency and variability. You can use the formulas too; but, they will be time consuming.EXCEL FUNCTIONSMeasures of Central TendencySuppose data are in cells A1 to A10Mean =AVERAGE(A1:A10)Median =MEDIAN(A1:A10)Mode =MODE(A1:A10)Measures of VariabilitySuppose data are in cells A1 to A10Range =MAX(A1:A10)-MIN(A1:A10)IQR =QUARTILE.EXC(A1:A10,3)-QUARTILE.EXC(A1:A10,1)Population Variance σ2 =VAR.P(A1:A10)Sample Variance s2 =VAR(A1:A10) or VAR.S(A1:A10)Population Standard Deviation σ =STDEV.P(A1:A10)Sample Standard Deviation s =STDEV(A1:A10) or STDEV.S(A1:A10)Joe and Mary would like to buy their first home in a new city. Below is the list of prices of 20 homes for sale. Prices in US Dollars140190265115270240250180160200240280175200310195320105385265 Find the mean, median, mode. (2 pts)Which measure of central tendency best represent the data? Why? (2 pts)Are there any outliers? If so, name the outlier. (2 pts)The ages of students in a statistics class are listed below. Age of students2220252327301831194545193627192633403524 Create a stem plot (2 pts)What is the mean age of the student? (2 pts)Jenny likes to have at least a 70% average to pass her statistics class. Her previous four test scores are 52%, 66%, 76% and 71%. What is the minimum score Heidi needs on the final exam to pass the class? (4 pts)Consider the following data and corresponding weights. Xi Weight (wi )3.152.332.8244 Compute the weighted mean. (2 pts)Compute the mean without weighting. (2 pts)The chart below represents the amount of rainfall for 15 days in northern Ohio in July. Rainfall in inches 4.14.23.53.94.24.43.83.73.53.44.33.24.34.5 4 Complete the frequency table. (2 pts) Rainfall in inchesFrequencyLess than 3.03.0-3.43.5-3.94.0-4.5Find the mean of the raw data. (2 pts)Find the median of the raw data. (2 pts)Find the mode of the raw data. (2 pts)Consider a sample with data values of 27, 25, 20, 15, 30, 34, 28 and 25.What is the minimum? (2 pts)What is the first quartile? (2 pts)What is the median? (2 pts)What is the third quartile? (2 pts)What is the maximum? (2 pts)Create the box plot for the data in #6. Label the five points on the box. (4 pts)Using the data in #6.What is the range? (2 pts)What is the interquartile range (IQR)? (2 pts)The histogram of a quantitative variable is positively skewed. The mean of the variable is 35.Which one of the following is a more likely value of the median? (2 pts)553035Support your answer. (2 pts)A histogram of a given data shows three clear peaks. This may mean that (4 pts) There are three distinct groups in the dataThere are three modes in the dataBoth a and b are correct

Throughout this course, you have practiced various skills that will allow you to identify, procure, and manipulate biosurveillance and secondary data. As addressed in previous sections, public health information needs are constantly growing, and the statistical analysis of data is just one step in this process. Decisions based on this information would rely not only on the accuracy of your analysis but also on the organization of its presentation. This week for your Scholar-Practitioner Project you will conduct descriptive and inferential analyses using your selected data set, your prepared database from Week 8, and SPSS. To prepare: Submit interpretation for your statistical analysis based on your selected data set, your prepared database, and SPSS. Mark sure to perform the following tasks for each of your research questions separately: Provide interpretation for descriptive statistical analyses based on your SPSS output. Summarize the numerical results with descriptive analysis tables or graphs, including your interpretation. Provide interpretation of your inferential statistical analyses using SPSS outputs. Summarize the numerical results with inferential analysis tables or graphs, including your interpretation.