Assignment project on Statistical Testing. The questions refer to the data given in the individual worksheets in Excel document ‘Assignment Datasets.xlsx
You must enter the last three digits of your student number (724) in the green cell of the first worksheet of your datasets spreadsheet document.
Be aware that the assignment excel document is locked against editing, to protect the mechanism by which I generate the numbers in your individual assignment. Do not attempt to get around this.
Please show a reasonable level of detail and explanation in your submission, so it is clear to anybody marking your work how you have arrived at your results. Remember, if your final answers to the questions are not correct, you will get more marks if your method is clear and it can be seen how much of your work was correct.
I am not accepting spreadsheet files in the online submission in order that they cannot be used to explain results; you should use a combination of the relevant equations and the English (or other human) language to explain how you arrived at your answer.
more information is in the screenshots and the PDF contains the questions needed to be answered. Don't make it look like too much AI or I wont get any marks
must be submitted as 1 pdf
Dataset 1 Assignment : Hypothesis Testing Type the last three digits of your student number in the green cell: 724 -6.3858086114 7.2161977237328 Dataset 1 7 20GroupsFrequencies 0.1300to307140.2768276259 0.75307to314164.4940491225 611314to3214028.5400756165 0.750.55321to3288871.6823966744 0.3328to3358871.6823966744 0.73335to3424328.5400756165 7.21619772370.84342to349164.4940491225 1.09304366850.79349to35690.2768276259 -2.32029980410.41 3.5348918850 5.0194141217 4.3447736691 -0.8256681468 -6.3858086114 &"Helvetica Neue,Regular"&12&K000000&P Dataset 2 -6.3995665772Assignment : Hypothesis Testing 10.0305516564 10.5712025005Dataset 2 20 0.1Part (a) 199.13197.45197.36206.31205.59198.39 0.75197.25199.44196.55207.15203.74200.33 196.20197.58198.44205.29201.96199.22 198.00195.89198.98203.38200.90199.37 198.46197.59200.88203.04201.43199.46 198.25195.82202.15204.17203.21197.56 196.66194.95201.71205.29202.86196.52 Part (b) 194.95196.13202.70203.37201.25198.44 196.27195.64204.50203.61200.04199.18 197.13203.70204.37202.25199.44197.27 7.21619772371.74454972141.42946881930.567578498128.20540392494.7849376051 1.09304366858.2070149019-1.200336283533.290221690122.187496484211.0983606367 -2.32029980412.17160034784.958420719727.226241038916.40595052647.5096519822 3.534891885-3.33769763486.702737337521.030847362412.95912671397.9954946561 5.01941412172.186243499712.890289358419.904663797114.67614571138.2756843436 4.3447736691-3.575939508717.0393316323.594112400220.46912794632.092205389 -0.8256681468-6.399566577215.582031398227.243026164119.3419752359-1.2931269219 -6.3858086114-2.543597478818.819923905920.9829390414.10956496054.940771586 -2.1000826861-4.165768468524.681527141421.764071182310.16502109897.3556017464 1.74454972141.42946881930.567578498128.20540392494.78493760512.4401072083 &"Helvetica Neue,Regular"&12&K000000&P Dataset 3 -6.3995665772Assignment : Hypothesis Testing 10.0305516564 10.5712025005Dataset 3 20 0.111.25 1500List (a) 101491.351474.531473.561563.141555.881483.871507.05 0.751472.521494.391465.471571.511537.381503.281519.41 1462.031475.841484.411552.871519.601492.251497.83 1480.031458.901489.771533.821509.001493.74 List (b) 1473.341464.631497.541519.111503.031483.351500.76 1471.271446.921510.301530.451520.841464.341490.69 1455.371438.241505.821541.671517.381453.941504.70 1438.281450.091515.771522.421501.291473.101483.49 1451.461445.101533.791524.821489.161480.53 7.21619772371.74454972141.42946881930.567578498128.20540392494.7849376051 1.09304366858.2070149019-1.200336283533.290221690122.187496484211.0983606367 -2.32029980412.17160034784.958420719727.226241038916.40595052647.5096519822 3.534891885-3.33769763486.702737337521.030847362412.95912671397.9954946561 5.01941412172.186243499712.890289358419.904663797114.67614571138.2756843436 4.3447736691-3.575939508717.0393316323.594112400220.46912794632.092205389 -0.8256681468-6.399566577215.582031398227.243026164119.3419752359-1.2931269219 -6.3858086114-2.543597478818.819923905920.9829390414.10956496054.940771586 -2.1000826861-4.165768468524.681527141421.764071182310.16502109897.3556017464 &"Helvetica Neue,Regular"&12&K000000&P Dataset 4 -6.3995665772 30.5675784981Assignment : Hypothesis Testing 20Dataset 4 0.1 0.75Resistance: 13 0.75Motor runningMotor not running 0.3713.7413.07-3.57593950870.08 0.213.4012.65-6.39956657720 7.21619772370.1113.2212.57-2.54359747880.1 1.09304366850.2713.5412.85-4.16576846850.06 -2.32029980410.3113.6213.081.4294688190.21 3.5348918850.2913.5812.97-1.20033628350.14 5.01941412170.1513.3012.864.95842071970.31 4.3447736691013.0012.606.70273733750.35 -0.82566814680.1213.2413.0112.89028935840.52 -6.38580861140.2213.4413.3217.039331630.63 -2.10008268610.413.8013.6415.58203139820.59 1.74454972140.2313.4613.3918.81992390590.68 8.20701490190.0813.1613.2524.68152714140.84 2.17160034780.2313.4613.7130.56757849811 -3.33769763480.0813.1613.4833.29022169011.07 2.1862434997013.0013.1627.22624103890.91 -3.57593950870.113.2013.1921.03084736240.74 -6.39956657720.0613.1213.0819.90466379710.71 -2.54359747880.1713.3413.4023.59411240020.81 -4.16576846850.1713.3413.5027.24302616410.91 &"Helvetica Neue,Regular"&12&K000000&P Dataset 5 0.7478569046 243.754514867Assignment : Hypothesis Testing 0.75 27.5Dataset 5130 0.250.1875 4.9843134833 61AdditiveYield -8.2535218701061118.35126.75451447170.52 0.250.037047249561.56118.45135.75451508810.56 61.250.074097521262.11118.49144.75451474290.59 0.74785690460.111136386362.67118.59153.75451493620.63 9.75058519780.148170935963.22118.68162.7545148280.67 18.75404789570.185207805863.78118.73171.75451488860.7 27.75473871420.222243362564.33118.82180.75451485460.74 36.75438085420.25927964864.89118.92189.75451487370.78 45.75458681420.296315523765.44118.96198.7545148630.81 54.7544736810.333351628366119.06207.7545148690.85 63.75453763860.370387604666.56119.15216.75451486560.89 72.75450202470.407423652767.11119.25225.75451486750.93 81.75452203020.444459660567.67119.29234.75451486650.96 90.75451084640.481495690968.22119.39243.7545148671 99.7545171156 108.7545136066 117.7545155723 &"Helvetica Neue,Regular"&12&K000000&P Dataset 6 Assignment : Hypothesis Testing 15Dataset 6 0.12 G1G2G3 A51719 B82019 SchoolC111625 D121930 E132028 0.75 27.47335336140.7517.631505417820.4749891164 26.72335336145.644648292821.262833949319.8477470775 9.530884451516.623700822323.8698573972 10.571613940520.092215109327.4733533614 12.768265141917.597971857326.7976836835 20.4749891164 31.4796358206 30.9903760536 &"Helvetica Neue,Regular"&12&K000000&P Reference 3 724 Student numbersLast3Seed value B0014235335310.75 B000983733731 B001019679670 B001435825821 B00147010101 B001468378370 B001406626621 B001485725721 B001466546541 B001454394391 B001466276271 B001463093091 B001377707700 B001414644641 B001451101101 B00140024241 B001028528520 B00147030301 B001423003001 B001444634631 B001433073071 B00141010101 B001465345341 B001491121121 B001349699690 B001205855851 B001444484481 B001464554551 B001432192191 B001426106101 B001367657650 B001363223221 B001464794791 B001458768760 B00146051511 B001279159150 B001466886881 B001388828820 B00132032321 B001429569560 B001419019010 B001386406401 B00141067671 B001444144141 B001399759750 B001362762761 B00144085851 B001425035031 B001407247240 B00134039391 B00142018181 B001404304301 B001448638630 B001421981981 B001424584581 B001418788780 B001411111111 B00137073731 B001461761761 B001353113111 B001455025021 B001481461461 &"Helvetica Neue,Regular"&12&K000000&P Statistics and Probability Summer Assignment on Hypothesis Testing May 31, 2023 Instructions This document contains the questions for your assignment project on Statistical Testing. The questions refer to the data given in the individual worksheets in Excel document ‘Assignment Datasets.xlsx’. Please read the following points. 1. All submissions must be in the form of PDF documents. Spread- sheets exported to PDF will be accepted, but calculations must be annotated or explained. 2. It is up to you how you do the calculations in each question, but you must explain how you arrived at your answer for any given calculation. This can be done with a written explanation and by using the relevant equations, along with showing the results of intermediate stages of the calculations. In other words, you need to show that you know how to do a calculation for a statistic other than using spreadsheet functions. 3. Each one of the questions involves a statistical test. Marks within each question will generally be awarded for: 1 • Deciding which statistical test to use, • Framing your Hypotheses and proper conclusions, • Identifying the parameters for the test and • Showing a reasonable level of clarity, detail and explanation in the calculations needed to carry out the test. 4. The data you have been given is in the worksheets of an Excel spreadsheet. This spreadsheet is locked against editing. Please to not try to circumvent this; if you wish to use a spreadsheet to do your calculations, you should copy and paste your data into your own spreadsheet and work with that. Question 1 The lifetimes (in units of 106 seconds) of certain satellite components are shown in the frequency distribution given in ‘Dataset1’. 1. Draw a frequency polygon, histogram and cumulative frequency polygon for the data. 2. Calculate the frequency mean, the frequency standard deviation, the median and the first and third quartiles for this grouped data. 3. Compare the median and the mean and state what this indicates about the distribution. Comment on how the answer to this ques- tion relates to your frequency polygon and histogram. 4. Explain the logic behind the equations for the mean and standard deviation for grouped data, starting from the original equations for a simple list of data values. (This does not just mean ’explain how the equations are used’.) Page 2 5. Carry out an appropriate statistical test to determine whether the data is normally distributed. Question 2 A manufacturer of metal plates makes two claims concerning the thickness of the plates they produce. They are stated here: • Statement A: The mean is 200mm • Statement B: The variance is 1.5mm2. To investigate Statement A, the thickness of a sample of metal plates produced in a given shift was measured. The values found are listed in Part (a) of worksheet ‘Dataset2’, with millimetres (mm) as unit. 1. Calculate the sample mean and sample standard deviation for the data in Part (a) of ’Dataset2’. Explain why we are using the phrase ’sample’ mean or sample’ standard deviation. 2. Set up the framework of an appropriate statistical test on State- ment A. Explain how knowing the sample mean before carrying out the test will influence the structure of your test. 3. Carry out the statistical test and state your conclusions. To investigate the second claim, the thickness of a second sample of metal sheets was measured. The values found are listed in Part (b) of worksheet ‘Dataset2’, with millimetres (mm) as unit. 1. Calculate the sample mean and then the sample variance and standard deviation for the data in Part (b). Page 3 2. Set up the framework of an appropriate statistical test on State- ment B. Explain how knowing the sample variance before carry- ing out the test would influence the structure of your test. 3. Carry out the statistical test and state your conclusions. Question 3 A manager of an inter-county hurling team is concerned that his team lose matches because they ‘fade away’ in the last ten minutes. He has measured GPS data showing how much ground particular players cover within a given time period; this is the data in list (a) in worksheet ‘Dataset3’. He has acquired the corresponding data from an opposing, more successful team, which is given in list (b). 1. Calculate the sample mean and sample standard deviation for the two sets of data. 2. Set up the frame work of an appropriate statistical test to deter- mine whether there is a difference in the distances covered by the two groups of players. 3. Explain how having the results of the calculations above in ad- vance of doing your statistical test will influence the structure of that test. 4. Carry out the statistical test and state your conclusions. Question 4 A study was carried out to determine whether the resistance of the control circuits in a machine are lower when the machine motor is Page 4 running. To investigate this question, a set of the control circuits was tested as follows. Their resistance was measured while the machine motor was not running for a certain period of time and then again while the motor was running. The values found are listed in worksheet ‘Dataset4’, with kilo-Ohms as the unit of measurement. 1. Set up the structure of an appropriate statistical test to determine whether the resistance of the control circuit in a machine are lower when the machine motor is running. 2. Explain how the order of subtraction chosen to calculate the dif- ferences will influence the structure of the test. 3. Give a reason why the data is measured with the engine not run- ning first and then with the engine running. 4. Explain how knowing the mean of the differences in advance will influence the structure of your statistical test. 5. Carry out the statistical test and state your conclusions. Question 5 A study was carried out to determine the influence of a trace element found in soil on the yield of potato plants grown in that soil, defined as the weight of potatoes produced at the end of the season. A large field was divided up into 14 smaller sections for this experiment. For each section, the experimenter recorded the amount of the trace element found (in milligrams per metre squared) and the corresponding weight of the potatoes produced (in kilograms). This information is presented in the worksheet ‘Dataset5’ in the Excel document. Define X as the trace element amount and Y as the yield. Page 5 1. Draw a scatterplot of your data set. 2. Calculate the coefficients of a linear equation to predict the yield Y as a function of X. 3. Calculate the correlation coefficient for the paired data values. 4. Set up the framework for an appropriate statistical test to estab- lish if there is a correlation between the amount of the trace ele- ment and the yield. Explain how having the scatterplot referred to above and having the value of r in advance will influence the structure of your statistical test. 5. Carry out and state the conclusion of your test on the correlation. 6. Comment on how well the regression equation will perform based on the results above. Question 6 A multinational corporation is conducting a study to see how its em- ployees in five different countries respond to three gifts in an incentive scheme. The numbers of employees who choose each of the three gifts (G1 to G3) in each of the five countries (A to E) are given in the table in ‘Dataset6’ in the Excel document. 1. Set up the structure of an appropriate statistical test to deter- mine whether the data supports a link between choice of gift and country, including the statistic to be used. 2. Carry out this test, showing clearly in your work how the expected values are calculated for your test statistic. Page 6 Submission All online submissions must be in the form of PDF documents. The Moodle submission link is set up so it will not accept spreadsheets or word documents. No email submissions will be accepted; if you cannot submit your PDF, get in touch by all means but do not email me with any files. If you do | will delete them immediately and notify you of this. You must enter the last three digits of your student number in the green cell of the first worksheet of your datasets spreadsheet document. Be aware that the assignment excel document is locked against editing, to protect the mechanism by which | generate the numbers in your individual assignment. Do not attempt to get around this. Please show a reasonable level of detail and explanation in your submission, so it is clear to anybody marking your work how you have arrived at your results. Remember, if your final answers to the questions are not correct, you will get more marks if your method is clear and it can be seen how much of your work was correct. | am not accepting spreadsheet files in the online submission in order that they cannot be used to explain results; you should use a combination of the relevant equations and the English (or other human) language to explain how you arrived at your answer.