EXCEL HOMEWORK 5
(70 PTS POSSIBLE)
Module/Week 6’s task has two elements. The target of your fifth Excel task is to be taught to assemble confidence intervals and conduct speculation checks in Excel primarily based on knowledge whose inhabitants parameters are identified. Additionally, you will reply questions on your outcomes. Half One entails setting up a confidence interval for the inhabitants imply primarily based on pattern knowledge; Half Two entails testing a speculation about the identical pattern compared to the identified inhabitants. First, ensure you view the presentation discovered within the Studying & Examine folder in Module/Week 6. This presentation offers info and goes by way of the steps you’ll need to be acquainted with with a purpose to full this task.
Analysis Query for Components 1 and a pair of: A well being psychologist desires to check general scholar well being on a college campus. One measure he decides to take is that of minutes exercised per week. Assume that we all know from earlier research that the inhabitants imply for minutes of train per week for school college students is μ = 100 with a typical deviation of σ = 25.
The well being psychologist in query is especially within the delusion of the “Freshmen 15.” This delusion claims that the majority freshmen acquire weight throughout the first yr of faculty, largely because of dangerous consuming habits and lack of train and sleep. He wonders if the Freshmen on his campus really train lower than the final inhabitants of faculty college students. He randomly selects a pattern of 50 Freshmen college students and asks them what number of minutes they train per week. The uncooked knowledge collected by the well being psychologist are on this module/week’s Information Set, entitled “Information Set 5”.
Half 1: Confidence Interval
1. Open the Excel file entitled “Information Set 5”. The file comprises the next: a) uncooked knowledge for the pattern 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 imply of minutes exercised per week.
a. First, fill in cells with info given within the analysis query above (N and sigma). (four pts)
b. Within the applicable cell within the desk, compute the pattern imply utilizing the uncooked knowledge given in column A. (Use the AVERAGE perform.) (four pts)
c. Decide the alpha stage for this downside and sort it within the applicable cell. (four pts)
d. As seen on this module/week’s presentation, use the CONFIDENCE perform to compute the 95% confidence interval within the applicable cell within the desk. (four pts)
e. Once more as seen within the presentation, compute the decrease and higher limits of the arrogance interval within the applicable cells.(four pts)
three. Reply all 5 questions beneath the primary desk. Sort solutions immediately into the Excel file as indicated. (Questions = three factors every for complete of 15 pts.)
Half 2: Speculation Take a look at
1. State the null and various (analysis) speculation in symbolic kind. The speculation needs to be written primarily based on the next info from the analysis scenario: “The well being psychologist in query is especially within the delusion of the ‘Freshmen 15.’ This delusion claims that the majority freshmen acquire weight throughout the first yr of faculty, largely because of dangerous consuming habits and lack of train and sleep. He wonders if the Freshmen on his campus really train lower than the final inhabitants of faculty college students (which has a μ = 100 and σ = 25).” (Do not forget that your speculation ought to embrace evaluators akin to =, <, > or a mix of those.) (2 pts)
2. Is your speculation directional or non-directional? Learn the wording once more in query 1 in case you are uncertain. The evaluators (=, <, >, and so forth.) you utilized in stating the hypotheses in query 1. above must also offer you a clue. Fill within the cell with both “one-tailed” or “two-tailed” primarily based on whether or not the choice speculation is directional or not. Additionally, should you fill in “one-tailed”, reply the query to the proper of the desk in regards to the route of the tail. This choice will assist you decide the crucial values of your check statistics later, so consider carefully! (2 pts)
three. Fill within the cells for N, μ, and σ that are already identified. These shall be utilized in formulation as proven on this week’s presentation. (2 pts)
four. Within the applicable cell within the desk, compute the Commonplace Error of the Imply (σM) utilizing the steps proven on this week’s presentation. (2 pts)
5. Fill within the pattern imply (M), once more utilizing the AVERAGE perform. (2 pts)
6. We’re going to check our speculation on the .05 stage of significance. Enter the alpha worth within the applicable cell. (2 pts)
7. Discover the crucial Z worth for our check, primarily based on the alpha stage, utilizing the NORMSINV perform as proven on this module/week’s presentation. Keep in mind to think about the route(s) of your speculation when computing this Z worth! (2 pts)
eight. Compute the pattern Z rating utilizing the steps gone over on this module/week’s presentation. (2 pts)
9. Fill within the crucial p-value primarily based in your alpha stage. (2 pts)
10. Compute your pattern’s p-value (primarily based in your pattern’s Z rating) by utilizing the NORMSDIST perform as proven on this week’s presentation. (2 pts)
11. Reply all 5 questions beneath the second desk immediately in Information Set 5, after every query as indicated. (Questions = three factors every for complete 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.
