Answered step by step
Verified Expert Solution
Question
1 Approved Answer
a. create a Box plot or me categorical data by gorng into plots cnoosrng bOXplotS and then Boxplot element and paste it below. Looking at
a. create a Box plot or me categorical data by gorng into plots cnoosrng bOXplotS and then Boxplot element and paste it below. Looking at the boxplots, which data set is the most normally distributed and what aspects of the plot did you use to determine this? 4. Now obtain zscores for the age data in excel by taking your sorted data and selecting it and pasting it on a new sheet within the file. Obtain the mean and the standard deviation for the data set. In the cell directly under the data insert an equal sign and type \"average\" and then select the data. Under the average obtain the standard deviation for the data by inserting \"= standev\" and selecting the data. Next you can enter the z-score equation in the cell next to the first calorie datum point. If your first data point is in cell A2, the equation will be: =(A2-$A$51)/$A$52) or =STANDARDIZE(A2,$A$51,$A$52). The $ sign makes sure the reference cell does not move. After obtaining the z-score for the first data point, click on the first z-score and drag down box to obtain the z-scores for the rest of the data. How many data points have an absolute z-score of 1.5 or higher? a. How many data points have an absolute z-score of 1.5 or higher? b. What percentage of ages have a z-score of 1.5 or greater? c. What age range does this z-score (2 =1.5) align with
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started