Question: Statistics with excel with frequency chart, how do i use excel to find the means, median etc? please list the steps on excel 1. A

Statistics with excel with frequency chart, how do i use excel to find the means, median etc? please list the steps on excel

 Statistics with excel with frequency chart, how do i use excel

1. A random sample of 1000 last names (surnames) is drawn from a student database at a local college. The distribution of the lengths of the names is as shown in the table below. Number of letters in last name 3 4 5 6 8 9 10 11 12 Frequency 13 102 186 237 215 113 83 32 13 6 allowed). You must perform the following calculations entirely using Microsoft Excel (no calculators Calculate the mean the median the (sample) standard deviation the range

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!