Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advanced Engineering Mathematics

Authors: Erwin Kreyszig

5th Edition

471862517, 978-0471862512

More Books

Students also viewed these Mathematics questions

Question

1. Compare and contrast mechanistic and organic organizations.

Answered: 1 week ago