Hello. Kindly help me with this one. Thank you
Page 1 of 6 STATISTICS & PROBABILIY: Second Grading Performance Task 1- 3 Hypothesis Testing and Correlation and Regression Analysis 0 This performance task aims to measure students' learning on the topics \"test on two related samples and simple regression and correlation analyses.\" 0 Unless specified, treat all CONTINUOUS data sets to be normally distributed. 0 Use Microsoft Excel to answer/ show the results of the calculation, graphs, etc. (worksheet, statistical coefficient). General Instruction for all the PT's Strictly follow instructions to avoid deductions. > Use short bond paper. Margin: Normal (1 inch on all sides) > You can encode and print your output, or handwritten but write neatly and legihly. No erasures. >9 Copy and answer > The rst page will be a cover page with the following information (per PT): Second Grading: Performance task #, Your complete name, Section, Date Submitted, and your subject teacher's name. Performance Task 1 Hypothesis Testing (Part 1) (30 points) I. Make a Time Table/ Time frame for your PT 1 (3 points) 11. Task: Read and analyze each given, then identify which test is appropriate to use. Conduct hypothesis testing following the steps. Use excel for your computation; on each item (copy- paste the Excel output). '2' A graduate student in psychology wanted to look into the inuence of gender on the perceived riskiness of risk behaviors as well as on the frequency of participation in risk behaviors. The mean scores for the risk behaviors are recorded in the table below. T able 1. Perceived 1e vel of H's/(1'11 ess of risk behavior among the male and female adolescent ofen ders. Male Thrill-seeking items 921 1 2.5 24 2 2.248 3 2.429 4 2.752 5 2.181 6 1.857 7 2.095 8 1.657 9 1.238 10 1.552 Total 20.533 Standard deviation 0.47357 Page 2 of 6 Male Female Rebellious items at] 222 1 2.448 2.177 2 2.524 2.258 3 2.762 2.226 4 1.543 1.371 5 2.029 1.323 6 1.781 1.403 7 2.371 1.371 Total 15.458 12.129 Standard deviation 0.43733 0.45733 Source: Master's thesis (Auatria 2008), Perceived Riskiness and Frequency of Participation in Risk Behaviors Among Selected Filipino Adolescent Offenders in Baguio City Test the following hypothesis: A. There is no significant difference between the perceived level of riskiness of thrill behavior in males and in females. (Use a: 0.05) Solution: Note: each letter (a, b, and c) should have like the table below as a solution. (7 points) Just copy the computed value form your excel output. Documentation: Screenshot your excel output showing the whole result and your name like the example below: (1 screen shot only) (2 points) REGICINS'I - Excel Your Name wiew View Help ,0 Search t-Test: Two-Sample Assuming Equal Variances 73 Mean 82.07692 86.15335 Variance 72.24359 20.30769 Ohservati 13 Or Page 3 of 6 Your Name Delacruz, Ivan STEM W PT2 - Saved art Page Layout Formulas Data Review View Help Search i Queries & Connections Clear Properties IIIII Filter Reapply Text to Ex Stocks La Edit Links Geography Sort Advanced Columns EO ~ Queries & Connections Data Types Sort & Filter Data Tools fc B C D E G H Private public 78.00 75.00 75.00 79.00 t-Test: Two-Sample Assuming Equal Variances 84.00 35.00 65.00 90.00 78 15 67.00 39.00 Mean 82.07692 86.15385 79.00 32.00 Variance 72.24359 20.80769 84 0n an on Ohconati B. There is no significant difference between the perceived level of riskiness of rebellious behavior in males and in females. (Use a= 0.10) - (9 points) > Do the same solution and documentation like in letter A. C. There is no significant difference between the level of riskiness of thrill-seeking items and rebellious items as perceived by the males. (Use a= 0.05). - (9 points) Do the same solution and documentation like in letter A. Performance Task 2 Hypothesis Testing (Part 2) (30 points) Make a Time Table/ Time frame for your PT 1 (3 points) II. Task: Read and analyze each given, then identify which test is appropriate to use. Conduct hypothesis testing following the steps. Use excel for your computation; on each item (copy- paste the Excel output) and fill out the necessary information in the box below the given problem. A. Four electronic calculators with different circuit types are being compared according to the response time in seconds. The following are the data gathered from the experiment. Does this indicate that one circuit type is more superior over the others? CIRCUIT TYPE A C D 0.27 0.26 0.14 0.46 0.19 0.35 0.17 0.44 0.15 0.33 0.18 0.38 0.45 0.22 0.2 0.43 0.17 0.35 0.15 0.33Page 4 of 6 Solution: Note: No need to put the 6 steps. Just follow what is specified below. 1. Documentation: Excel output- Screenshot showing the result and your name just like in PT 1 (4 points) 2. Fill out the table below (3 points) CIRCUIT TYPES MEAN DE P-VALUE Legend: 0.00 - 0.20 Very Fast (VF) * * Highly significant 0.21 - 0.40 Moderately Fast significant (MF 0.41 - 0.60 Slow (S) ns Not significant BRIEF INTERPRETATION: (3 points) B. The table below shows the birth weights of three groups of infants classified by the mother's smoking status based on the number of packs of cigarette she consumes in a day. Determine whether there is a significant difference among the three groups of weights at the 5% level. Table 2: Infant Birth Weights According to the Smoking Status of the Mother Number of packs of cigarette per day None 1 pack More than 1 Birth wt (kg) Birth wt (kg) Birth wt (kg) 4.05 3.74 2.71 .23 2.75 2.61 3.94 2.84 2.52 3.86 3.44 3.6 3.88 3.83 3.18 3.23 3.88 2.2 3.59 3.42 1.82 3.18 3.51 3.45 3.42 2.88 2.79 3.51 3.05 3.26 Patterned from Bohnenblust and Kuzma(2015) Solution: 1. Documentation: Excel output- Screenshot showing the result and your name just like in PT 1 (4 points) 2. Ho and Ha: (2 points)ll. 3. Fill u the ANOVA table and draw a u u ro - riate decision and conclusion 3 Beeweeeeeeees Page 5 of 6 --- Total Decisions: (2 points) Conclusions: (3 points) C. What generalization can you draw from the activity? 2- 4 sentences only. (3 points) Performance Task 3: Correlation and Regression Analysis (30 points) Make a Time Table/ Time frame for your PT 1 (3 points) Task: Read and analyze each given, then identify which test is appropriate to use. Conduct hypothesis testing following the steps. Use excel for your computation; on each item (copy-paste the Excel output]. . An article in the Iournal of Sound and Vibration described a study investigating the relationship between noise exposure and hypertension. The data given in the table are representative of those reported in the article. ID Noise Pressure Blood (decibels) Pressure 1 2 65 2 2 63 3 3 65 4 2 71 5 4 75 6 1 81 7 3 80 8 5 96 9 1 85 10 3 80 Solution: ID 11 12 13 14 15 16 17 18 19 20 Noise Pressure (decibels) ooou-wpoowepep O\\\\l 1. Documentation: Excel output just like in PT 1 and 2. (4 points) Blood Pressure 83 9O 90 88 88 95 96 92 100 100 2. Do these data provide sufficient evidence that there is a positive linear relationship between the two variables? (2 points) 3. What does R"2 imply? (2 points) Page 6 of 6 4. Using the regression model, predict the blood pressure level associated with a sound pressure of 7.5 decibels. (2 points) 5. Fill out the table below (2 points) Regression Value P-value R" 2 parameters bo b1 Legend: ** Highly significant * significant ns Not significant BRIEF DESCRIPTION: (3 points) B. The following data provides the grades of 10 randomly selected engineering students on their Statistics Class, and a course on Operations Research. Are the two variables, Statistics Performance and Operations Research Performance significantly correlated? ID Statistics Grade Operations Research Statistics Grade Operations Research 1 88 81 93 95 2 78 82 83 80 3 73 75 4 75 84 5 90 92 Solution: 1. Documentation: Excel output just like in PT 1 and 2. (4 points) 2. Fill up the table below. (2 points) Pearson's r DE P-value Legend: ** Highly significant * significant ns Not significant BRIEF DESCRIPTION: ( 3points) C. What generalization can you draw from the activity? 2- 4 sentences only. (3 points) References: Garambas, Z. U. (2011). Basic Probability and Statistics. Valencia Educational Supply
