Question: Internet usage (Gigabytes) last month 55 65 56 97 72 92 58 77 59 67 92 86 92 95 87 92 60 59 94 62

Internet usage (Gigabytes) last month
55
65
56
97
72
92
58
77
59
67
92
86
92
95
87
92
60
59
94
62
54
66
74
75
58
90
97
88
55
51
75
59
66
69
57
74
54
63
50
97
63
78
89
81
62
90
80
79
61
79

All work for this question must be done in the worksheet named Question 1.

This worksheet can befound in the data fileAssignment Data.

  1. Using Excel, obtain a Descriptive Statistics output of the internet usage from a random sample of 50 people during the previous month. (Mean, Mode, Range and Standard Deviation) * [1]

  1. Using Excel, construct a histogram with appropriate bin widths

(with 7 classes). * [2]

  1. Using the information from the descriptive statistics output and the histogram, write one paragraph describing the data set. You must include information about the mean, mode, range, standard deviation and the shape of the distribution, of the data in your answer. [2]

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!

Q:

Although airline schedules and cost are important factors for business travelers when choosing an airline carrier, a USA today survey found that business travelers list an air-lines frequent flyer...

Q:

Internet usage (Gigabytes) last month 55 65 56 97 72 92 58 77 59 67 92 86 92 95 87 92 60 59 94 62 54 66 74 75 58 90 97 88 55 51 75 59 66 69 57 74 54 63 50 97 63 78 89 81 62 90 80 79 61 79 All work...

Q:

Please answer questions on the bottom 1 2 3 4 5 6 7 8 A Obs 1 2 3 4 5 6 7 8 9 9 10 11 12 10 13 11 14 12 15 13 16 14 17 15 18 16 19 17 20 18 21 19 22 20 23 21 24 22 25 23 26 24 27 25 28 26 29 27 30 28...

Q:

ID Gender 1M 2F 3M 4F 5M 6M 7F 8F 9F 10 M 11 M 12 M 13 F 14 F 15 M 16 F 17 F 18 M 19 F 20 F 21 M 22 F 23 M 24 F 25 M 26 F 27 M 28 M 29 F 30 F 31 F 32 M 33 M 34 F 35 F 36 F 37 M 38 M 39 M 40 F 41 M 42...

Q:

The Excel file Chipotle provided in the corresponding assignment link consists of data related to predicting the level of business ( Usage Level ) obtained from a survey of purchasing managers of...

Q:

Player At Bats Hits 1 127 2 271 3 343 4 281 5 311 6 257 7 263 8 196 9 213 10 217 11 599 12 306 13 594 14 510 15 574 16 458 17 530 18 313 19 233 20 528 21 687 22 394 23 453 24 190 25 547 26 472 27 581...

Q:

attachments_17587411b95d6d44bfe708c8f87050cd4003e827 MovieTitle The Hunger Games: Catching Fire Iron Man 3 Frozen Despicable Me 2 Man of Steel Gravity Monsters University The Hobbit: The Desolation...

Q:

This is what I submitted to my teacher regarding the project so far: Briefly describe your data set and its characteristics. Data Set includes Race results for all NASCAR Winston Cup races between...

Q:

ST130: Basic Statistics Assignment 2, Semester 1, 2021 Due Date: Friday 20 th June, 2021, 5pm (Fiji-time) Total Marks: 60 Weight: 15% Instructions: 1. All questions are compulsory. Use MS excel to...

Q:

ST130: Basic Statistics Assignment 2, Semester 1, 2021 Due Date: Friday 20 th June, 2021, 5pm (Fiji-time) Total Marks: 60 Weight: 15% Instructions: 1. All questions are compulsory. Use MS excel to...

Q:

d & e text values: 1 2 2 2 3 2 4 3 5 3 6 3 7 6 8 8 9 9 10 9 11 10 12 10 13 14 14 19 15 20 16 23 17 37 18 41 19 42 20 48 21 56 22 64 23 67 24 76 25 80 26 82 27 87 28 100 29 101 30 106 31 121 32 135 33...

Q:

Abernathy Corporation was organized on January 1, 2012. It is authorized to issue 10,000 shares of 8%, $50 par value preferred stock, and 500,000 shares of no-par common stock with a stated value of...

Q:

The sales and cost data for two companies in the transportation industry are as follows: X Company Y Company Amount Percent Amount Percent Sales $ 122,000 100.00 $ 122,000 100.00 Variable costs...

Q:

Use the substitution z = y / x to solve the initial value problem y = ( x ^ 2 - y ^ 2 ) / xy with y ( 2 ) = 5 . Give an explicit solution in the form y = f ( x )

Q:

A stable sort does not change the order of elements with the same value. This is a desirable feature in many applications. Consider a sequence of e-mail messages. If you sort by date and then by...

Q:

Based on the 12 characteristics of personal excellence described in the text, which of these do you think most salespeople lack? Do you possess the potential for excellence in selling? Why or why not?

Q:

Postal bar codes. For faster sorting of letters, the United States Postal Service encourages companies that send large volumes of mail to use a bar code denoting the zip code (see Figure 7). The...

Q:

Find the missing properties of P, v, s, and x for CO 2 and indicate each state on a Ts diagram relative to the two-phase region. a. 20C, 2000 kPa b. 20C, s = 1.49 kJ/kg-K c. 10C, s = 1 kJ/kg-K

Q:

What are the advantages and disadvantages to allowing ownership to be transferred by the passage of documents of title?

Q:

11.15 Management has stated that it will tolerate one stockout per year. The forecast of annual demand for a particular SKU is 100,000 units, and it is ordered in quantities of 10,000 units. The lead...

Q:

Make eye contact when talking and listening

Q:

Do not go, wait until I come

Q:

Pay him, do not wait until I sign