Friends 129 349 51 50 273 361 110 108 99 27 45 243 122 196 63 134 95 162 179 739 203 84 172 104 293 61 38 64 75 88 116 95 123 71 94 38 9 226 73 69 203 155 40 56 27 62 11 5 Create a histogram using Excelâ€™s Data Analysis toolpack for Friends. Use the Sturgesâ€™ rule to find...

70.2K

Verified Solution

Question

Statistics

Friends
129
349
51
50
273
361
110
108
99
27
45
243
122
196
63
134
95
162
179
739
203
84
172
104
293
61
38
64
75
88
116
95
123
71
94
38
9
226
73
69
203
155
40
56
27
62
11
5
Create a histogram using Excelâ€™s Data Analysis toolpack forFriends. Use the Sturgesâ€™ rule to find how many bins you shouldinclude. In your Word file, make sure to in- clude both a frequencytable for the histogram with bin limits, frequencies and relativefrequencies, and your histogram chart. What can you say about thedistribution of Friends? All calculations should be shown in excel.(Along with the answer, can anyone give me the instruction on howto do the histogram and solve the questions using excel?).

Answer & Explanation Solved by verified expert

4.0 Ratings (421 Votes)

To create a histogram using Excels Data Analysis toolpackfollow the steps1 Type all your values in a column2 Find how many bins are required from Sturges Rule It statesthatthe number of groups or classes is 1 33 log n where n is thenumber of observationsHere n is 48 So the number of classes comes out to be See Answer

Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:

Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!

Become a Member