HW1

xlsx

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

Report
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