Satistical math | Psychology homework help

EXCEL HOMEWORK 5
(70 PTS POSSIBLE)

Module/Week 6’s process has two components. The goal of your fifth Excel process is to be taught to assemble confidence intervals and conduct hypothesis checks in Excel based totally on information whose inhabitants parameters are recognized. Moreover, you’ll reply questions in your outcomes. Half One entails establishing a confidence interval for the inhabitants suggest based totally on sample information; Half Two entails testing a hypothesis concerning the similar sample in comparison with the recognized inhabitants. First, make sure you view the presentation found throughout the Learning & Study folder in Module/Week 6. This presentation affords information and goes by the use of the steps you will have to be acquainted with with a function to full this process.
Assessment Question for Elements 1 and a pair of: A nicely being psychologist needs to verify normal scholar nicely being on a school campus. One measure he decides to take is that of minutes exercised per week. Assume that everyone knows from earlier analysis that the inhabitants suggest for minutes of practice per week for varsity school college students is μ = 100 with a typical deviation of σ = 25.

The nicely being psychologist in question is particularly throughout the delusion of the “Freshmen 15.” This delusion claims that almost all freshmen purchase weight all through the primary yr of college, largely due to harmful consuming habits and lack of practice and sleep. He wonders if the Freshmen on his campus actually practice decrease than the ultimate inhabitants of college school college students. He randomly selects a sample of 50 Freshmen school college students and asks them what variety of minutes they practice per week. The raw information collected by the nicely being psychologist are on this module/week’s Data Set, entitled “Data Set 5”.
Half 1: Confidence Interval
1.    Open the Excel file entitled “Data Set 5”. The file contains the subsequent: a) raw information for the sample of 50 Freshmen; b) a outcomes desk for Half 1; c) Questions for Half 1; d) a outcomes desk for Half 2; and e) Questions for Half 2.

2.    Assemble a 95% Confidence Interval of the inhabitants suggest of minutes exercised per week.
a.    First, fill in cells with information given throughout the Assessment question above (N and sigma). (4 pts)
b.    Throughout the relevant cell throughout the desk, compute the sample suggest using the raw information given in column A. (Use the AVERAGE carry out.) (4 pts)
c.     Resolve the alpha stage for this draw back and type it throughout the relevant cell. (4 pts)
d.    As seen on this module/week’s presentation, use the CONFIDENCE carry out to compute the 95% confidence interval throughout the relevant cell throughout the desk. (4 pts)
e.    As soon as extra as seen throughout the presentation, compute the lower and better limits of the vanity interval throughout the relevant cells.(4 pts)

three.    Reply all 5 questions beneath the first desk. Kind options instantly into the Excel file as indicated. (Questions = three components each for full of 15 pts.)
 
Half 2: Hypothesis Check out
1. State the null and varied (Assessment) hypothesis in symbolic type. The hypothesis must be written based totally on the subsequent information from the Assessment state of affairs: “The nicely being psychologist in question is particularly throughout the delusion of the ‘Freshmen 15.’ This delusion claims that almost all freshmen purchase weight all through the primary yr of college, largely due to harmful consuming habits and lack of practice and sleep. He wonders if the Freshmen on his campus actually practice decrease than the ultimate inhabitants of college school college students (which has a μ = 100 and σ = 25).” (Don’t forget that your hypothesis should embrace evaluators akin to =, <, > or a mixture of these.) (2 pts)

2. Is your hypothesis directional or non-directional? Be taught the wording as soon as extra in question 1 in case you’re unsure. The evaluators (=, <, >, and so forth.) you utilized in stating the hypotheses in question 1. above should additionally give you a clue. Fill throughout the cell with each “one-tailed” or “two-tailed” based totally on whether or not or not the selection hypothesis is directional or not. Moreover, do you have to fill in “one-tailed”, reply the question to the right of the desk regarding the route of the tail. This selection will help you resolve the essential values of your verify statistics later, so take into account fastidiously! (2 pts)

three. Fill throughout the cells for N, μ, and σ which can be already recognized. These shall be utilized in formulation as confirmed on this week’s presentation. (2 pts)

4. Throughout the relevant cell throughout the desk, compute the Commonplace Error of the Indicate (σM) using the steps confirmed on this week’s presentation. (2 pts)

5. Fill throughout the sample suggest (M), as soon as extra using the AVERAGE carry out. (2 pts)

6. We’ll verify our hypothesis on the .05 stage of significance. Enter the alpha value throughout the relevant cell. (2 pts)

7. Uncover the essential Z value for our verify, based totally on the alpha stage, using the NORMSINV carry out as confirmed on this module/week’s presentation. Bear in mind to consider the route(s) of your hypothesis when computing this Z value! (2 pts)

eight. Compute the sample Z score using the steps gone over on this module/week’s presentation. (2 pts)

9. Fill throughout the essential p-value based totally in your alpha stage. (2 pts)

10. Compute your sample’s p-value (based totally in your sample’s Z score) by using the NORMSDIST carry out as confirmed on this week’s presentation. (2 pts)

11. Reply all 5 questions beneath the second desk instantly in Data Set 5, after each question as indicated. (Questions = three components each for full of 15 pts.)

Save your work as “yourname_excel5.xls” and submit it by 11:59 p.m. (ET) on Monday of Module/Week 6.