Homework instructions:Please calculate the standard deviation for the variable "SIBS." You will have to scroll towards the right of the spreadsheet to see it as it is listed in column AF.Note that if you click on the variable "SIBS", you can see the all of the information that is actually written in that cell.The answers are listed as the number of siblings a respondent, or survey participant, reported.These answers are "face valid," meaning "1" indicates that respondent reported having 1 sibling, etc.

Please copy the output below.

STANDARD DEVIATION of SIBS

4.700527223 <----- is this right?

Based on your knowledge of

1)how central tendency measures relate to determining whether a dataset is normally distributed or skewed;

If the median is greater or less than the mean, then it is skewed. If the mean and the median are the same then it is normally distributed.

2) how standard deviation relates to the spread of scores around the mean, do you believe that this dataset has a normal distribution or a skewed distribution?

Chapter 4

You are to calculate the z-score that is associated with the equivalent raw score for EACH of the raw score options listed below from the variable "SIBS." Use the mean and standard deviation calculated in the first part of the homework under descriptive statistics.

Using the "Standardize" Excel function (p. 94), please transform the raw score answers to their respective z-scores.It is NOT necessary to select, or highlight, the variable to calculate the z-score for a specific raw score.In fact, it may seem easier to use a blank Excel spreadsheet so as not to type over any information.The formula for transforming a raw score into a z-score is listed below.While I encourage you to use Excel, those who feel comfortable simply plugging the numbers into the formula may do so as it is a straight-forward formula.

Number of Siblings, X

What is the z-score when the raw score X = 0?

What is the z-score when the raw score X = 1?

What is the z-score when the raw score X = 2?

What is the z-score when the raw score X = 3?

What is the z-score when the raw score X = 4?

What is the z-score when the raw score X = 5?

What is the z-score when the raw score X = 6?

What is the z-score when the raw score X = 7?

If you have correctly calculated the z-scores for the above raw scores, when X = 3 or less, the transformed Z-score is negative.On the other hand, when X = 4 or more, the transformed z-score is positive.Why would that be?