KEMBAR78
Midterm Data | PDF | Standard Deviation | Histogram
Scribd
Upload
83 views6 pages

Midterm Data

MacroSwift polled 36 executives to determine the amount of available hard drive space on their PCs to develop a new software program. The mean amount of available space was 229.05 MB with a standard deviation of 179.456 MB. The interquartile range was 369 MB, indicating a wide variation in the available hard drive space among the executives' PCs.

Uploaded by

Abhijit Dhar
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
83 views6 pages

Midterm Data

MacroSwift polled 36 executives to determine the amount of available hard drive space on their PCs to develop a new software program. The mean amount of available space was 229.05 MB with a standard deviation of 179.456 MB. The interquartile range was 369 MB, indicating a wide variation in the available hard drive space among the executives' PCs.

Uploaded by

Abhijit Dhar
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 6

16. The fill amount of soft drink bottles is normally distributed, with a mean of 2.

0 liters and a standard deviation of


than 95% of the listed net content (1.90 liters, in this case), the manufacturer may be subject to penalty by the offic
that have a net content above 2.10 liters may cause excess spillage upon opening. What proportion of the bottles w

a. between 1.90 and 2.0 liters?


b. between 1.90 and 2.10 liters?
c. below 1.90 liters or above 2.10 liters?
d. 99% of the bottles contain at least how much soft drink?

Mean 2
SD 0.05

A) P(1.90<= X <= 2.0)

P(1.9<=X) 0.02275
P(X<=2.0) 0.5

P(1.90<= X <= 2.0) 0.47725

The portion of bottles will contain between 1.9 and 2 liters is 0.4772

B) P(1.90<= X <= 2.1)

P(1.9<=X) 0.02275
P(X<=2.1) 0.97725

P(1.90<= X <= 2.1) 0.9545

The portion of bottles will contain between 1.9 and 2.1 liters is 0.9545

C) P(1.9<X>2.1)

P(1.9<X) 0.02275
P(X>2.1) 0.02275

P(1.90<= X <= 2.1) 0.0455

The portion of bottles will contain between 1.9 and 2.1 liters is 0.0455

D) z= (X- mu)/ sigma

X= mu + z*sigm
X= 1.8835

99% of the bottles contain atleast 1.88 liters of soft drink


and a standard deviation of 0.05 liter. If bottles contain less
bject to penalty by the office of consumer affairs. Bottles
proportion of the bottles will contain:

liters is 0.4772
MacroSwift Data

17. MacroSwift has decided to develop a new software program designed for CEOs and other high-level executives.
to develop a program that required too much hard-drive space, so they polled 36 executives to determine the amou
their PCs. The results are given below in megabytes. Show the Descriptive Statistics and Draw a Histogram. Calculate
Comment on your observations.

X Amount of available space in PCs (Megabytes)

X
6.3 Column1 Q1 39.225
6.7 Q2 214.85
7.9 Mean 229.05 Q3 408.175
8.4 Standard Error 29.909364807
9.7 Median 214.85 IQR 368.95
10.6 Mode #REF! Lower fence -514.2
12.4 Standard Deviation 179.45618884 Upper fence 409.675
19.4 Sample Variance 32204.523714
29.1 Kurtosis -1.6318313985
42.6 Skewness 0.0638506154
59.8 Range 496.3
97.6 Minimum 6.3
100.4 Maximum 502.6
120.6 Sum 8245.8
135.5 Count 36
148.6
178.6
200.1
229.6
284.6
305.6
315.6
325.9
347.5
358.6
397.8
405.6
415.9
427.8
428.6
439.5
440.9
472.3
475.9
477.2
502.6
her high-level executives. MacroSwift did not want
es to determine the amount of available space on
aw a Histogram. Calculate the Interquartile range.

This chart isn't available in your version of Excel.

Editing this shape or saving this workbook into a different file format will
permanently break the chart.

You might also like