Question
Directions What are the three characteristics of a normal curve? (3 pts) Why do we use standard scores? (2 pts) Problem 3: Using Excel -
Directions
- What are the three characteristics of a normal curve? (3 pts)
- Why do we use standard scores? (2 pts)
Problem 3:
Using Excel - Download a copy of the file (UNIT_5_ASSIGN_PART_I_PROBLEM_3.xlsx Download UNIT_5_ASSIGN_PART_I_PROBLEM_3.xlsx) that has the a sample of five values listed below. calculate the mean and standard deviation (STDEV.s) of the five values:
Variable X | Z-Scores | Mean | ||
12 | Standard Deviation | |||
15 | ||||
11 | ||||
13 | ||||
10 |
3. In Excel - using the observed value, mean, and standard deviation - calculate the five z-scores utilizing your preferred function/formula. Provide a screenshot of the z scores from Excel and paste it into your assignment document (be sure I can see the numbers and labels clearly). (5 pts)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored 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