HW1
xlsx
keyboard_arrow_up
School
University of North Dakota *
*We aren’t endorsed by this school
Course
315
Subject
Statistics
Date
Feb 20, 2024
Type
xlsx
Pages
20
Uploaded by DoctorDragonflyMaster198
HW1
7 problems
100 points
Problem 1
15 points
Here is a set of 100 random numbers. Consider this our "population" of all possible n
11.70747402553
1.35941551502 12.47596788774 9.719295609997 12.98432236886
15.43594411439 4.859812829273
0.73946006593 12.65715329378
1.30145089095
11.99063675584
6.48256072877 4.167631084175 4.449560564557 18.80843424112
7.92905021426 11.26706816064 10.05640520016
6.63850652458 17.75618203877
1.299377738791
0.75310491532
16.958189853 17.84249391945 0.160840773884
10.74935767532
13.3410871432 10.70742288565 17.66023983462 2.764470389778
12.33266995507 5.740616649608 1.207145785425 18.65864678937 8.764803411793
13.57892033576 17.68179270964 2.553041053936 4.707299180885 11.20375846127
11.48771078996 15.03739870782 12.66118305248 17.04413379887 6.616645665504
13.34366711997 1.967681182085 17.86470937444 9.650941703596 15.42996885786
a) Find the mean and standard deviation of this entire set of numbers
Mean
10.13441700988
St.Dev.
5.629556523451
b) Select a sample of ten of these numbers. Find the mean and standard deviation of
Mean
St. Dev.
Sample 1
10.98548087249 3.928676281474
Sample 2
7.849053854137 6.078259263033
Sample 3
8.939115624294 6.370739131358
Sample 4
8.939115624294 5.636678083834
Sample 5
11.90282712197
6.77917132805
c) Comment on how the sample statistics differ from the population statistics
Problem 2
15 points
For the data below, make an ordered list and calculate the 25th, 50th, and 75th percen
3.2
4.3
6.5
7.5
Quartiles
P%
Q1
7.249765817582
Q2
22.69841076651
Q3
33.66223438838
The sample is only a small selected portion of the entire value set, while governs the value set in its entirety.
Problem 3
20 points
Using the random number function, create a set of 100 values with an average of aro
To prevent the data from changing, do a Copy, then Paste Special > Values Only to m
49.83890214428 50.94118086128 50.23035626038 50.72564972218 49.97200547383
50.3345382115 48.39233180217
50.3120842422 49.89115201866 49.24316465792
50.3387289083
47.314411855 52.02032483484 50.41354643494
48.5224809858
49.07499393497 49.30512337493
50.1974564702 51.10366226655 50.57216819916
48.73086453997 50.75323360502 50.48560649484 50.26414762762 50.12386695319
48.53174292311 50.88452092997 51.56733476249 50.11033028233 51.45712305283
50.50218200396 49.59189264093 50.16583751801 50.46108481937
49.1216666024
49.18549380266 49.99609230229 50.98644173849 50.51733866576 50.52832643462
50.14654287086 48.30087841109 50.44810473591 50.37417833956 50.94819908252
48.52616208661 51.05061421331
49.7226244131 51.04178259874 51.39473142319
Copy Format
47.96421124769 50.14211972852 51.92547313489 51.71715910894
50.0647918349
48.25706179295
50.6288514404 50.97378721311
51.7235605699 50.51537444846
48.80243506986 51.36305393925 49.99575618857 49.31544990039 50.71325247413
49.12733591702 51.07408058742 52.68160799247 48.93714244226 51.14427337984
49.61892616983
48.9229114355 49.07424537888 49.85262351305 49.20468562571
49.73642011035 49.90564424496 48.86881995154 50.51256663055 49.38475488685
50.4647444274 49.30018366553 49.65451461405 48.95860380424 49.92571654809
50.58564557854 50.13578414887
52.1920319019 50.28312786103 49.48012625567
50.65525044984 49.81202549039 49.25623000669 50.79202692464 50.32510119645
51.38886189924 49.22322201558 51.79554200483 49.48688158232 49.97189182977
Problem 4
20 points
Using the same values as above, create a histogram in Mintab. Save the graph as an
Problem 5
10 points
There are 15 numbers on a list, and the smallest number is changed from 12.9 to 1.29
a) Is it possible to determine by how much the mean changes? If so, by how much do
b) Is it possible to determine the value of the mean after the change? If so, what is th
c) Is it possible to determine by how much the median changes? If so, by how much d) Is it possible to determine by how much the standard deviation changes? If so, by
Problem 6
20 points
Given the data below:
Sample No.
[C] (mg/L)
1
284.34
2
173.01
3
229.55
4
312.95
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
5
215.34
6
188.72
7
144.39
8
172.79
9
139.38
10
197.81
11
303.28
12
256.02
13
658.38
14
105.14
15
295.24
16
170.41
a) Compute the mean concentrartion
240.421875 (mg/L)
b) Compute the median concentration
206.575 (mg/L)
c) Compute the first quartile of the concentrations
172.195 (mg/L)
d) Compute the third quartile of the concentrations
287.065 (mg/L)
e) Construct a boxplot for the concentrations. What features does it reveal?
Problem 7
A vendor converts the weights on the packages she sends out from pounds to kilogr
(1kg approximately equals 2.2 pounds).
a) How does this affect the mean weight of the packages?
b) How does this affect the standard deviation of the weights?
c) If the vendor gegins using heavier packages, which increases the weight of each p
The boxplot features the X which is the mean value, the lower whisker shows the minim
value, the upper whisker the max value. The line within the box indicates the median val
The box itself indicates the lower portion is the first quartile while the upper box is the t
quartile. There is also a dot which exists as an outlier. The Center of the upper and lower
bounds of the box indicates the largest(upper) IQR and the smaller(lower) IQR.
how much does this affect the mean weight of the packages?
numbers. **Note, the function rand() continuously recalculates each time you hit enter. 14.0587527866 18.84011218382 8.194203076669 13.41244513158 19.73366768022
9.565315786399 4.797903806261
8.24093768711 0.539934981201 0.983271115273
11.96983183467
14.5743779965 12.88536712661
15.3706500308 7.646099309012
6.352256052162 14.12714860031 10.10434379121
2.70319481578 7.760141597716
7.928666091773 12.50179343667 10.34240454388 9.290250871696 14.90555780975
6.933128246325
1.15804539205 4.849762750451 18.78988748959 2.173407661179
9.766885841703 0.113313522354 10.48163420558 5.936170075098 7.256908423747
9.328884751012 10.05429592356 19.59223001724 14.51817146553
17.1077824917
15.64585106862 19.11982053292 13.74779145412 19.06219103823 2.653506986733
4.850574273378 10.87067581288 14.77873105529 16.74442475218 8.523345784441
f this sample. Do this for five different samples.
ntiles. 17.7
22.3
23.1
23.7
32.8
36.1
the population
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
ound 50 (doesn't need to be exact). Use the histogram tool (under the Data Analysis Toolpak) to create
make this a static set of numbers
50.9800036551 49.66693933408 49.29839802716 49.78471715731 48.02721971122
49.05048864596 49.38400380248 49.73925871679 49.76073732356
49.1563666047
49.81601843394 50.51352036421
50.6632128457 49.86774959154
50.3645599472
49.64669758225 48.47946797918 51.52101616183 48.69904875498 48.96746445216
49.4641624062 49.31583877236 50.12979483576 51.70978069308 50.48235536042
51.35098302526 50.66887892669 50.77369300483 48.07083748109 49.40770107096
49.95954534771
49.5785787473 51.49368999246 49.13506827378 50.32424119995
50.28112013502 49.59188578824 49.73625707067 49.50030207765 48.39503110818
50.22468820968 49.70865110217 51.38231531745 49.97368893832
49.7427208181
49.91176099583 50.88699829278
49.8994813529 50.35043260904 51.72551560984
50.06227899735 49.93467803616 51.77509201001 48.93944065758 50.33766922949
49.35988255706 50.76320990739 49.24113389346 49.02501271811 49.66020049387
49.65509681824 48.52794505738 48.65709926968 48.84402702929
51.8139147588
51.07008042286 50.97083958065
52.3663451153 51.28087761407 49.72094135627
49.86905960143 50.55614732429 51.70010052808 48.96298567475 49.08825402204
50.88344683666 50.93092661006 50.90445383037 49.26009094217 51.71376275138
49.70243793103 50.54898678558 51.14309081812 49.71617783928 49.74486207244
50.99078502364 49.36708902818 49.56443986145 51.51393881631 49.87066961202
48.21403936614 49.41927431445 50.67590411458 51.14036026842 48.75628127347
51.09053949335 49.40271719454 52.04220289555 50.52309528849 50.38756615312
n image, then insert it here. Just the graph, not the minitab file. 9.
oes it change?
he value?
does it changes?
y how much does it change?
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.
A) Since the number decreased from 12.9 to 1.29 the total value dec
change cannot be determined without the full set of values. B) We cannot determine the mean without the full set of 15 numbe
C) The median does not change since the smallest number is only ch
median. D) Without the mean and the other sets of values we cannot determ
sample variance which we would need to square root to determine
rams
package by 50 g; break the chart.
mum lue. third r A-B) This does not affect the mean or St.Dev of the packages, it only changes the weights unit measurement, thus only affects the multiplier of the mean and the dividing factor of the deviation by the 2.2 pound conversion. C)
The mean would increase by the mulitplier factor of 50g or 0.05kg, the mean would rema
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
The mean would increase by the mulitplier factor of 50g or 0.05kg, the mean would rema
but become larger as the overall weight of the population becomes larger.
47.2
47.7
e a new histogram using this data.
Min
47.96421124769
Bin
Frequency
Max
52.68160799247
47.96421124769
1
Mean
50.15525340358
48.3
2
StDEv
1.038584584576
48.5
0
48.79052583487
3
Bins
47.96421124769
49.05842021103
9
48.3
49.32631458719
10
48.5
49.59420896334
8
48.79052583487
49.8621033395
11
49.05842021103
50.12999771565
9
49.32631458719
More
47
49.59420896334
49.8621033395
50.12999771565
0
20
40
Histo
Bin
Frequency
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
creased, therefore the mean will decrease as well, but the ers. hanged in value, since there are 15 total values, n=15, 16/2 = 8 mine the standard deviation because we cannot calculate the the STDEV.
of standard ain the same
ain the same
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
ogram
Frequency
47.9642112
48.2140394
min
47.9642112
BINS
47.9642112
48.2570618
max
52.681608
48.3
48.5279451
Mean
50.1552534
48.5
48.6570993
StDEV
1.03858458
48.7905258
48.7562813
49.0584202
48.8024351
49.3263146
48.844027
49.594209
48.86882
49.8621033
48.9229114
50.1299977
48.9371424
48.9394407
48.9586038
48.9629857
49.0250127
49.0742454
49.088254
49.1273359
49.2046856
Bin
Frequency
49.223222
47.9642112
0
49.2411339
48.3
3
49.25623
48.5
0
49.2600909
48.7905258
3
49.3001837
49.0584202
9
49.3154499
49.3263146
10
49.3598826
49.594209
8
49.367089
49.8621033
11
49.3847549
50.1299977
9
49.4027172
More
47
49.4192743
49.4801263
49.4868816
49.5644399
49.6189262
49.6545146
49.6550968
49.6602005
49.7024379
49.7161778
49.7209414
49.7364201
49.7448621
49.8120255
49.8526235
49.8690596
0
20
40
Frequency
49.8706696
49.9056442
49.9257165
49.934678
49.9718918
49.9957562
50.062279
50.0647918
50.1357841
50.1421197
50.2831279
50.3251012
50.3376692
50.3875662
50.4647444
50.5125666
50.5153744
50.5230953
50.5489868
50.5561473
50.5856456
50.6288514
50.6552504
50.6759041
50.7132525
50.7632099
50.7920269
50.8834468
50.9044538
50.9309266
50.9708396
50.9737872
50.990785
51.0700804
51.0740806
51.0905395
51.1403603
51.1430908
51.1442734
51.2808776
51.3630539
51.3888619
51.5139388
51.7001005
51.7137628
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
51.7171591
51.7235606
51.775092
51.795542
51.8139148
51.9254731
52.0422029
52.1920319
52.3663451
52.681608
Histogram
Frequency
Bin
Related Documents
Recommended textbooks for you
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:9781133382119
Author:Swokowski
Publisher:Cengage
Recommended textbooks for you
- Algebra & Trigonometry with Analytic GeometryAlgebraISBN:9781133382119Author:SwokowskiPublisher:Cengage
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:9781133382119
Author:Swokowski
Publisher:Cengage