nstructionsIn this assignment, you will calculate confidence intervals for the quantitative variables in the Heart Rate Dataset.StepsOpen the Heart Rate Dataset in Excel and identify the quantitative variablesMake sure the data is sorted by category (e.g.male-at-rest, female at-rest, etc.)Use the Data Analysis tools of Excel to construct 95% and 99% confidence intervals for all 8 categories of the sorted quantitative variables. Excel will calculate the margin of error given as the “confidence interval” in the output. Use this margin of error to create your 8 confidence intervals by both adding and subtracting it from the sample mean (calculated in unit 3). This creates a range of values that is the confidence interval.Create a Word document, and use your calculated results to explain what the confidence intervals tell us. What do these confidence intervals tell us about our heart rate data? How would you interpret the 95% and 99% intervals for resting heart rate?Compare the 99% and 95% intervals and explain why one is larger than the other even though we use the same sample mean value.Additional Instructions:Your assignment should be typed into a Word or other word processing document, formatted in APA style. The assignments must includeRunning headA title page withAssignment nameYour nameProfessor’s nameCourse

CompetencyThis competency will allow you to demonstrate your ability and skill in analyzing nonzero-sum games and synthesizing optimal strategies within them.InstructionsDuring the city's mayoral race one of the candidates hires G&B Consulting. This candidate is a challenger from the same party as the incumbent mayor and is vying to be put on the ticket in the general election. She believes that the nomination will likely come down to what stance she takes on a proposed tax bill. The bill is for a tax increase that would subsidize education grants. Staying within traditional party lines would be advantageous to gaining support from the core constituency, but going against party lines on the issue would help sway swing voters and independents. The issue is bound to come up at an upcoming debate and she wants the help of G&B Consulting to determine an optimum strategy.To complete this assignment, you must first download the word document. Your step-by-step breakdown of the problems, including explanations, should be present within the word document provided.

PART1: Assessing NormalityIn this module, you explore the normal distribution. A standard normal distribution has a mean of zero and a standard deviation of one. The z-score statistic converts a non-standard normal distribution into a standard normal distribution allowing us to use Table A-2 in your textbook (or whatever technology you want!) and report associated probabilities.This discussion combines means, sample standard deviation, z-score, and probability. You are encouraged to complete the textbook reading, review the narrated Ppts., and start the MyStatLab Homework before starting this discussion.ScenarioThe following table reports simulated annual flying squadron costs (in millions of dollars) at the following locations:Module 4 Airshow Template.xlsxCompleteUse Microsoft Excel and StatDisk to complete the Flying Squadron Costs table for the aircraft type listed below:If your last name begins with the letter A through L, compute the mean costs (x-bar) and sample standard deviation (s) using the B-52 data; use the Kadena mean cost (x) in your z-score and probability calculations.If your last name begins with the letter M through Z, compute the mean costs (x-bar) and sample standard deviation (s) using the F-35 data; use the Charleston mean cost (x) in your z-score and probability calculations.Report your values to two decimal places (i.e., 0.12) except for probability (four decimal places). Report probability, i.e., area, (to the right of your z-score) values to four decimal places (i.e. p = 0.1234).Your StatDisk results should look very similar to this image:Save your work as separate files to your computer and then read the Canvas instructions on How do I embed an image in a discussion reply as a student? (Links to an external site.)Links to an external site.Post & DiscussEmbed the images of your spreadsheet and StatDisk results in the discussion area along with a narrative (interpretation and understanding) of your findings and the responses to the questions below.Do these costs appear to come from a population that has a normal distribution? Why or why not?Can the mean of your data sample be treated as a value from a population having a normal distribution? Why or why not?Did an “unusually low” or “unusually high” z-score value occur? See Ppts.Was the associated z-score probability value less than 0.05 (p < 0.05); meaning a “significantly low” or “significantly high” event? If yes, what are the implications for the base and/or aircraft?What were your findings? Hint: focus on the calculated mean, standard deviation, and z-score (include probability) to interpret your results.You should make your initial post before the fourth day of the module week (Friday) to receive full credit. Return at least twice later in the module week to provide meaningful (substantive) comments to two or more of your classmates' posts. DO NOT “post and run” – making all three posts in the same visit. You need multiple visits to the discussion area to gain multiple perspectives by reading all of the posts and replies.Review the Discussion Rubric for detailed grading information.PART2Flying Squadron Costs ReportAssignmentReport the CostsNow that you have calculated simulated annual flying squadron costs, you are required to report your findings. Remember the focus for this module is the normal distribution; specifically mean, standard deviation, z-score, and probability; what these descriptive and inferential statistics physically mean and how they are used in a simulated “real-world” problem.You are encouraged to calculate all row and column values for mean, standard deviation, z-score, and probability so that the entire “data picture” is available. (Hint: Are there any unusual events? Either by aircraft or base?)Report the costs in a Memorandum of Understanding (MOU). Your MOU should be a maximum of one page with one-inch margins using 11 point font and consist of only the following three paragraphs:Introduction - Prepare the audience for what they are about to read.Results - The facts.Conclusion(s) - Results are fact-based, concise and to the point; actionable.Review the Writing Suggestions page for tips. Use this format for your document.MEMORANDUM OF UNDERSTANDINGTO: 97th AMW - USAFFROM: Your NameDATE: Add Assignment Due DateSUBJECT: Determined by StudentSubmitSave your assignment using a naming convention that includes your first and last name and the activity number or description (i.e., STAT_211_Last_Name_First_Name_Module_4). Do not add punctuation or special characters.This assignment will automatically be checked through Turnitin, a service that checks your work for improper citation or potential plagiarism by comparing it against a database of web pages, student papers, and articles from academic books and publications.Review the Assignment Rubric for detailed grading information.