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
0 0
Add a comment Improve this question Transcribed image text
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.

96 97 98 1 100.2738 101.6089 97.3934 100.608 100.0483 98.3731 99.2734 100.0729 103.4057 102.5725 98.3296 102.846 100.4672 99.

Then we will select data data analysis from Analysis tab and select HistogramData Analysis Analysis Tools OK Anova: Single Factor Anova: Two-Factor With Replication Anova: Two-Factor Without Replication

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

Histogram Input Input Range: Bin Range: OK Cancel Help SBS1:SBS10d SCS1:SCS9 Labels Output options O Qutput Range: O New Work

We will get the histogram plot as follows

Bin Frequenc 0 Histogram 97 1 4 e 30 20 10 100 101 102 103 104 26 30 Frequency 10 11 More 12 1 Bin 0

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

lisf Function Argument AVERAGE Number B2:B11 0,1:4;2326:30:114:1:0 number Number2 Bi 10 Returns the average (arithmetic mean)

Similarily we will find standard daviation also by using STDEV Function Arguments STDEV Number1 B2:B11 10:14:23:26:30:11:4; 1;0) = Number2 number 1 1 .8321 5957 = This function is availabl

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

Function Arguments NORMDIST x B10 Mean B12 Standard_dev B14 I = 10 = 11.83215957 Cumulative TRUE TRUE 0.22343641 This functio

Add a comment
Know the answer?
Add Answer to:
ALL WORK DONE IN EXCEL, SHOW SCREENSHOT. MATLAB!! BELOW IS SOAP BOX 1 100.2738 2 101.6089...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • 1.         For each set below, using Excel, construct            a.         a frequency distribution,   ...

    1.         For each set below, using Excel, construct            a.         a frequency distribution,    b.         a relative frequency distribution, and            c.         a cumulative relative frequency distribution. Consider whether or not you should group your data. Describe how you determined your bin width, if you grouped the data in intervals. Set 1 75    95    103 100 93 91 90 92 89 105 86 85 81 96 103 99 94 95 91 97 92 107...

  • 5-8 show work 5. 6. At a local high school 5000 juniors and seniors recently took...

    5-8 show work 5. 6. At a local high school 5000 juniors and seniors recently took an aptitude test. The results of the exam were normally distributed with mean - 450 and o = 50. Calculate the following: a. The PERCENT of students to the nearest tenth of a percent that scored over 425 b. The number of students that scored more than 475 c. The probability of a student selected at random having scored between 400 and 575 A...

  • all the answers must be done please help and codes should be done in matlab Part C (Based off week 12 workshop...

    all the answers must be done please help and codes should be done in matlab Part C (Based off week 12 workshop content Sinee the implementation of the CityCyele scheme in October 2010, the Bris bane council has recorded the mamber of City Cycle trips every month The results are available in the CityCycleData.cov' fie on Blackboard 1. Import the data into MATLAB using the cavread fuaction, and the visualise the data with the scatter function Coenment on whether a...

  • please check I have included all data needed. Question 2. (Minitab or R and Excel) Normal, clean rain has a pH value of...

    please check I have included all data needed. Question 2. (Minitab or R and Excel) Normal, clean rain has a pH value of between 5.0 and 5.5, which is slightly acidic. However, when rain combines with sulfur dioxide or nitrogen oxides— produced from power plants and automobiles—the rain becomes much more acidic. Typical acid rain has a pH value of 4.0. The data are the pH of precipitation observed in Colorado. a) Make a histogram of the data in 3...

  • 1. a. In Wireshark, for packet 92, what information in the IP header indicates that the...

    1. a. In Wireshark, for packet 92, what information in the IP header indicates that the datagram has been fragmented? b. What information in the IP header indicates whether this is the first fragment versus a latter fragment? How long is this IP datagram? 2. a. For packet 93, what information in the IP header indicates that this is not the first data fragment? Are there more fragments? If so, how can you tell? - 0 X IP_traceFile File Edit...

  • I literally have no idea what I’m doing. Help!!! Please show work!! Write an essay using...

    I literally have no idea what I’m doing. Help!!! Please show work!! Write an essay using Word and post it as an attachment to the discussion. Cover the following points. Choose a data set from Stat Disk using one of the following files from 13th Edition Elementary Statistics: Oscar Winner Freshman 15 Word Count Garbage Weights Passive and Active Smoke If the file contains more than one variable, choose a quantitative variable. Create a histogram using your chosen variable and...

  • Please show all work and explain here is the data and explanation of 12.4 here is appendix D

    please show all work and explain here is the data and explanation of 12.4 here is appendix D 12.12. * In Problem 12.4, find the value of x2. If the dice really are true, what is the probability of getting a value of X2this large or larger? Explain whether the evidence suggests the dice are loaded. (See Appendix D for the necessary probabili- ties.) 12.4.I throw three dice together a total of 400 times, record the number of sixes in...

  • HULPU To recieve full credit you must show all work #1. To determine whether the pipe...

    HULPU To recieve full credit you must show all work #1. To determine whether the pipe welds in a nuclear power plant meet specifications a random sample of welds is selected, and tests conducted on each. Weld strength is measured as the force required to break the weld. Suppose the specifications state that mean strength of welds should exceed 100lb/in the inspection team decides to test H = 100 versus H: > 100. Why is this better than H: <...

  • PL CRM AG Best OLD 900 6000 15 1 ViewSonic requirements using an Excel spreadsheet. Refer...

    PL CRM AG Best OLD 900 6000 15 1 ViewSonic requirements using an Excel spreadsheet. Refer to Chap lor ideas on how to structure the spreadsheet. and Deferrals COMPREHENSIVE PROBLEM The trial balance of Pacilio Security Services Inc. as of January 1, 2012, was as follows: Cash Land Notes Payable Common Stock Retained Earnings $8,500 4,000 5,000 6.000 1,500 During 2012, Pacilio Security Services experienced the following transactions 1. Acquired an additional $2,000 from the issue of common stock 2....

  • data: (copy and paste in excel to view columns in alignment) Sample   Repair Time (days) 1  ...

    data: (copy and paste in excel to view columns in alignment) Sample   Repair Time (days) 1   12 2   17 3   9 4   16 5   10 6   18 7   12 8   14 9   15 10   14 11   14 12   8 13   11 14   10 15   8 16   8 17   14 18   12 19   14 20   13 21   12 22   15 23   15 24   10 25   24 26   17 27   13 28   15 29   13 30   15 31   36 32   40 33  ...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT