Question: Document: https://drive.google.com/file/d/12lvBb6V_O9a1THEJlOYblouC-Txvxbns/view?usp=sharing You will examine a data set that gives the number of words spoken in a day by 106 male and 116 female subjects
Document: https://drive.google.com/file/d/12lvBb6V_O9a1THEJlOYblouC-Txvxbns/view?usp=sharing
You will examine a data set that gives the number of words spoken in a day by 106 male and 116 female subjects aged 17 to 23.

2. Consider the word counts spoken by female subjects in the sample to answer the following questions. a. (Submit a screenshot of the frequency distribution table.) Construct a frequency distribution table of the data. Begin with a lower class limit of 1,500 and use a class width of 6,000. b. (Submit a screenshot of the histogram.) Use Excel to construct a histogram based on the frequency distribution table. C. (Submit a screenshot from Excel.) Use Excel to compute the following measures: mean, median, standard deviation, variance, and range. Beside each calculated value, clearly label the name of the measure. d. ( Submit a screenshot of your written or typed explanation.) Describe the shape of this distribution as skewed right, skewed left, or bell-shaped. Refer to the mean and median to explain your
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
