Kibata

Sign In

Our Services

Get 15% Discount on your First Order

Order Now
[rank_math_breadcrumb]

help with Statistics

can you help me complete this projected 

Inferential Statistics

Submit your assignment using this template. Feel free to add additional work at the bottom, but the top must remain.
There are five tables in this worksheet: two for statistical summary, two for confidence intervals, and one for hypothesis tests.
To find a table quickly, press Ctrl+G. Press the Tab key to move to input areas of the table.
Note: See the worksheet named “Example” (in the bottom tab) for examples of how to fill in the yellow boxes.
Blank row, Table 1 begins in A8.
Blank row, Table 1 begins in A8.
Statistical Summary: Questions 1–4 Confidence Intervals: Questions 1–4
Question Sample Proportion Sample Size Question Error Lower Limit Upper Limit Conclusion
#1 #1
#2 #2
#3 #3
#4 #4
End of Table 1, blank row. Table 2 begins in F8. End of Table 2, blank row. Table 3 begins in A15.
Statistical Summary: Questions 5–6 Confidence Intervals: Questions 5–6
Question Sample Mean Sample Std Dev Sample Size Question Error Lower Limit Upper Limit Conclusion
#5 #5
#6 #6
End of Table 3, blank row. Table 4 begins in F15. End of table, blank row. Table 5 begins in F21.
Blank row. Table 4 begins in F15. End of table, blank row. Table 5 begins in F21.
Table 5 begins in F21. Hypothesis Tests: Questions 1–6
Question Ho Ha Reject Ho When Test Statistic Decision Summary
#1 p p
#2 p p
#3 p p
#4 p p
#5 μ μ
#6 μ μ
End of table, blank row.
Rejection criteria:
Left-tailed test (one-sided), reject Ho when z < -1.645.
Right-tailed test (one-sided), reject Ho when z > 1.645.
Two-tailed test (two-sided), reject Ho when z < -1.96 or z > 1.96.
End of worksheet.

IMPORTANT:
Be sure you change the population statistic in the Test Statistic formula to reflect what you put in Ho and Ha.

Example

The work below uses made-up data. Remember that the values you use in your hypotheses are up to you.
You can compare your population parameters to any value; just remember that the sample statistic must agree with your alternate hypothesis.
We always try to reject the null hypothesis; that means we must have evidence (via the sample statistic) that the alternate hypothesis is true.
Click in the cell to see the formula used.
Blank row, Table 1 begins in A8.
Blank row, Table 1 begins in A8.
Statistical Summary: Questions 1–4 Confidence Intervals: Questions 1–4
Question Sample Proportion Sample Size Question Error Lower Limit Upper Limit Conclusion
#1 0.56 61 #1 0.1271116716 0.4328883284 0.6871116716 We are 95% confident the true population proportion is between 0.293 and 0.547
#2 0.43 61 #2 0.1267759092 0.3032240908 0.5567759092 We are 95% confident the true population proportion is between 0.604 and 0.836.
#3 0.48 61 #3 0.1279344094 0.3520655906 0.6079344094 We are 95% confident the true population proportion is between 0.453 and 0.707.
#4 0.44 61 #4 0.1271116716 0.3128883284 0.5671116716 We are 95% confident the true population proportion is between 0.527 and 0.773.
End of Table 1, blank row. Table 2 begins in F8. End of Table 2, blank row. Table 3 begins in A15.
Statistical Summary: Questions 5–6 Confidence Intervals: Questions 5–6
Question Sample Mean Sample Std Dev Sample Size Question Error Lower Limit Upper Limit Conclusion
#5 3.61 1.43 61 #5 0.3661854766 3.2438145234 3.9761854766 We are 95% confident the true population mean is between 14.72 and 15.92.
#6 492.03 136.62 61 #6 34.9847970729 457.0452029271 527.0147970729 We are 95% confident the true population mean is between 118.17 and 123.95.
End of Table 3, blank row. Table 4 begins in F15. End of table, blank row. Table 5 begins in F21.
Blank row. Table 4 begins in F15. End of table, blank row. Table 5 begins in F21.
Table 5 begins in F21. Hypothesis Tests: Questions 1–6
Question Ho Ha Reject Ho When Test Statistic Decision Summary
#1 p ≥ 0.55 p < 0.55 z < -1.645 0.1569919254 Reject Ho There is sufficient statistical evidence to show the population proportion is less than 0.55.
#2 p ≤ 0.50 p > 0.50 z > 1.645 -1.0934349546 Reject Ho There is sufficient statistical evidence to show the population proportion is greater than 0.50.
#3 p = 0.60 p ≠ 0.60 z < -1.96 or z > 1.96 -1.913112647 Do not Reject Ho There is not sufficient statistical evidence to show the populaton proportion is not 0.60.
#4 p ≥ 0.75 p < 0.75 z < -1.645 -5.5914696935 Reject Ho There is sufficient statistical evidence to show the population proportion is less than 0.75.
#5 μ = 17 μ ≠ 17 z < -1.96 or z > 1.96 -73.1323378744 Reject Ho There is sufficient statistical evidence to show the population mean is not 17.
#6 μ ≤ 119 μ > 119 z > 1.645 21.3252630406 Do not Reject Ho There is not sufficient statistical evidence to show the population mean is greater than 119.
End of table, blank row.
Rejection criteria:
Left-tailed test (one-sided), reject Ho when z < -1.645.
Right-tailed test (one-sided), reject Ho when z > 1.645.
Two-tailed test (two-sided), reject Ho when z < -1.96 or z > 1.96.
End of worksheet.

IMPORTANT:
Be sure you change the population statistic in the Test Statistic formula to reflect what you put in Ho and Ha.

Remember that the values used in the hypotheses are whatever you want; just make sure the sample statistic supports Ha.

FORMAT HINT:
Copy the math notation to another cell using copy, then paste. Right-click in the cell to see these options.

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Order Now

Related Questions

Critical Review

See attached  Critical Review of Published Article  Mastery of statistics involves not only the ability to generate sound statistical results, but also the ability to critically evaluate the statistical analysis of others.  This is the focus of this assignment.  A critique is not a summary or a simple retelling of

Statistic Worksheet Help

Need help understanding the fundamentals of statistics. Overview For this week’s assignment, you’ll apply some of the research methods you read about in Chapters 1 and 2 by analyzing a scenario. You’ll also explore how statistics are used in various fields. Preparation Before you begin this assignment, complete the following:

Math W4

Using Excel to Determine Probabilities for Binomial Distributions In this week’s assignment, we will learn how to use Excel to calculate probabilities for a binomial distribution. · The resource to consult: Section 4.3 Binomial Distribution. · Resource to consult: Section 5-2  Triola Stats.com es13 excel videos  View video and then

STATISTICSwk4

2 By now you are adept at calculating averages and intuitively can estimate whether something is “normal” (a measurement not too far from average) or unusual (pretty far from the average you might expect). This class helps to quantify exactly how far something you measure is from average using the

Mathematical Statistics W3

Using Excel to Calculate Factorials, Permutations, and Combinations In this week’s assignment, we will learn how to use Excel to calculate factorials, permutations and combinations. A resource to Section 4-4 of  Stats Video Collection  Assignment View the video and then complete the following tasks in a blank Excel worksheet.  4-4

MATHHH

Forum 2 (Week 2): Historical Mathematician (CA Group) Choose one Historical Mathematician and discuss the contributions of that man or woman. You could choose to consider: ways in which this person changed the world through mathematics, particular challenges that they faced, ways in which faith and religion impacted his/her life

MATHHH

WEEK 1 MATH102 Scripture contains a variety of interesting material involving numbers. Here are a few examples: (a) The approximation of Pi in the Old Testament. (b) The symbolism of special numbers; for example, 1, 3, 7, 12, and 144,000. (c) Hebrew and Greek representation of numbers and their translation

College Algebra

Must follow grading rubric. Probability Report Worksheet Directions: Complete the probability report worksheet to help you with your calculations to create the APA report. 1. Choose one of the three scenarios: a. Probability of obtaining heads on a coin toss b. Probability of rolling a 2 on a 6-sided die.

worksheet

  Identification of Methods and Interpretation of Results

Journal post

Help organizing my thoughts IHP 340 Module Five Short Paper Guidelines and Rubric Overview This short paper assignment will help you understand hypothesis testing and its relationship to research questions. Prompt Read the short paper scenario below and answer the questions using the scenario and what you have learned in

Milestone 2

Help understand statistic milestones IHP 340 Milestone Two Guidelines and Rubric Overview In Milestone Two, you will continue composing your final project by adding additional information on research methods and key findings. Prompt For this milestone assignment, address the following in the article you have selected for the final project:

Mathematics homework help

I need support with a math question. I will attach the document for review.  Borough of Manhattan Community College Mathematics Department Name___________________________ Instructor L. Erstenyuk Date ___________________________ MAT 216-_____________ EXAM 1 REVIEW Instructions. Show all steps and label answers. Papers will be graded on clarity, neatness and organization as well

Math 1342 excel spresdsheet

Can anyone help with excel and statistic? 1. Top of Form Again, you will use the student survey from the Excel spreadsheet given at the beginning of the course:  MATH 1342 Database.xlsx Find two free cells in the spreadsheet to enter the appropriate formulas to find the mean and standard deviation

Operations Management: Process Selection and Cost Analysis

I’m currently working on an assignment for my Operations Management course and need assistance with process selection based on cost analysis. Scenario: A company is evaluating two production processes for a new product: Process A: Fixed Costs = $50,000; Variable Cost per Unit = $10   Process B: Fixed Costs

MA 2025 MOD 6 ASSN

  For this assignment, you will utilize statistical technology to work with a series of datasets. You are welcome to use the technology of your choice including Excel, Desmos, and Google Sheets.  Please follow the instructions below. Once you have completed the assignment, submit your completed document (in .docx or

College Algebra

Must follow grading Rubic Financial Report Worksheet Directions: Complete the financial report worksheet to help you with your calculations to create the APA report. 1. Go to your financial institution’s website or a local financial institution’s website and find the interest rate and compounding frequency (monthly, quarterly, annually, and so

Mathematics Major Assignment

This assignment uses a scoring guide. Review the scoring guide on the first tab of the spreadsheet prior to beginning the assignment to become familiar with the expectations for successful completion. 

frequency table and pie chart help?

You should have many more colors and the frequencies should be based on what you count (for each color) from the main  spreadsheet that I provided. Once completed, highlight all of the cells of your completed frequency table, by selecting and dragging your pointer through all of the cells. Select