Question

ALL WORK DONE IN EXCEL, SHOW SCREENSHOT. MATLAB!!

Download the data file "soapbox.txt" from eCampus Plot a histogram of the data Repeat the analysis done in the PPT ·Compute mean and standard deviation Determine the probability that the box weight is between 100 and 101 oz. Determine the probability that the box weight is greater than 103 oz. Determine the probability that the box weight is less than 99 oz. ·Challenge question: by trial and error, can you determine what box weight is exceeded only 5% of the time? ·Submit a pdf file

BELOW IS SOAP BOX
1       100.2738
2       101.6089
3       97.3934
4       100.608
5       100.0483
6       98.3731
7       99.2734
8       100.0729
9       103.4057
10      102.5725
11      98.3296
12      102.846
13      100.4672
14      99.6551
15      100.4562
16      99.5089
17      99.5921
18      101.2544
19      101.1713
20      101.1797
21      100.4116
22      98.4763
23      100.4588
24      101.3991
25      100.2236
26      100.7857
27      100.4687
28      99.4075
29      100.0227
30      98.9091
31      100.635
32      98.5385
33      98.6191
34      98.8862
35      96.6874
36      101.2015
37      100.0549
38      98.9424
39      101.1314
40      97.9571
41      99.6147
42      99.4713
43      100.0488
44      100.0422
45      98.8292
46      99.689
47      99.5502
48      100.3665
49      100.8461
50      100.8626
51      98.8304
52      99.7997
53      98.4695
54      98.5731
55      99.7129
56      101.2986
57      98.9272
58      100.1025
59      99.4876
60      100.8709
61      98.5983
62      99.7535
63      100.2891
64      100.8536
65      101.3105
66      99.8085
67      98.1837
68      98.9554
69      98.6266
70      102.141
71      99.0859
72      100.4905
73      99.5218
74      100.6353
75      98.9322
76      98.2757
77      98.255
78      100.2228
79      99.5373
80      99.5181
81      101.1819
82      100.0203
83      99.9237
84      101.3553
85      98.8914
86      100.4375
87      100.5801
88      99.469
89      99.9421
90      98.5192
91      98.5376
92      99.828
93      100.4639
94      102.3831
95      99.0331
96      99.913
97      99.635
98      97.729
99      99.2679
100     97.8715

Answer 1

We will define the interval of the values to be used and here the values are in the range of 96-104, so we will use interval of 1 in column C.

We will define the interval of the values to be used and here the values are in the range of 96-104, so we will use interval of 1 in column C. A B C D 1 100.2738 96 2 101.6089 97 3 97.3934 98 4 100.608 99 5 100.0483 100 6 98.3731 101 7 99.2734 102 8 100.0729 103 9 103.4057 104 10 102.5725 11 98.3296 12 102.846 13 100.4672 14 99.6551 165 100.4562 16 99.5089 17 99.5921 Then we will select data analysis from Analysis tab and select Histogram in input range we will specify the 100 values which are in B1: B100 and in bin range we will specify the interval C1: C9 and tick chart plot and new excel option We will get the histogram plot as follows Bin Frequency 96 0 97 1 98 4 99 23 100 26 101 30 102 11 103 4 104 1

Then we will select data data analysis from Analysis tab and select Histogram

in input range we will specify the 100 values which are in B1:B100 and in bin range we will specify the interval C1:C9 and tick chart plot and new excel option

We will get the histogram plot as follows

To calculate mean of the data click on a blank tab and select fx and then select average and specify the column B1:B11

Similarily we will find standard daviation also by using STDEV

To find the probability that the weight of box will be greater than 103 we will select the column and then we fill selext fx and NORMDIST then we will select 1 infront of 103 and then select mean and standard daviation cell and click OK