Assessment#4
Inferential Statistics
Your assessment must be submitted using this tem plate. 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
ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
#2
#2 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
#3
#3 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
#4
#4 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
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 Size Question Error Lower Limit Upper Limit Conclusion
#5
#5 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
#6
#6 ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0!
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.
When Test Statistic Decision
Summary
#1 p p ERROR:#DIV/0!
#2 p p ERROR:#DIV/0!
#3 p p ERROR:#DIV/0!
#4 p p ERROR:#DIV/0!
#5
μ ERROR:#DIV/0!
#6 μ μ ERROR:#DIV/0!
End of table, blank row.
Rejection criteria:
Lefttailed test, reject Ho when
. Righttailed test, reject Ho when
z > 1.645. Twotailed test, 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
Blank row, Table 1 begins in A8.
Blank row, Table 1 begins in A8.
Confidence Intervals: Questions 1–4
Question Sample Proportion Sample Size Question Error Lower Limit Upper Limit Conclusion
#1
28883284
#2 0.43 61 #2 #361 #3
#461 #4 0.1271116716
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
61 #5
#661 #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
z < 1.645
#2z > 1.645
Do not Reject Ho
#3Do not Reject Ho
#4z < 1.645
Reject Ho
#5z < 1.96 or z > 1.96
Reject Ho
#6z > 1.645
Reject Ho
End of table, blank row.
Rejection criteria:
End of worksheet.
The work below uses madeup 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.  
Statistical Summary: Questions 1–4  
0.56  61  0.1271116716  0.43  0.6871116716  We are 95% confident the true population proportion is between 0.433 and 0.687.  
0.1267759092  0.3032240908  0.5567759092  We are 95% confident the true population proportion is between 0.303 and 0.557.  
0.48  0.1279344094  0.3520655906  0.6079344094  We are 95% confident the true population proportion is between 0.352 and 0.608.  
0.44  0.3128883284  0.5671116716  We are 95% confident the true population proportion is between 0.313 and 0.567.  
3.61  1.43  0.3661854766  3.2438145234  3.9761854766  We are 95% confident the true population proportion is between 3.244 and 3.976.  
492.03  136.62  34.9847970729  457.0452029271  527.0147970729  We are 95% confident the true population proportion is between 457.045 and 527.015.  
p ≥ 0.55  p < 0.55  0.1569919254  Do not Reject Ho  There is not sufficient statistical evidence to show the population proportion is less than 0.55.  
p ≤ 0.50  p > 0.50  1.0934349546  There is not sufficient statistical evidence to show the population proportion is greater than 0.50.  
p = 0.60  p ≠ 0.60  z < 1.96 or z > 1.96  1.913112647  There is not sufficient statistical evidence to show the populaton proportion is not 0.60.  
p ≥ 0.75  p < 0.75  5.5914696935  There is sufficient statistical evidence to show the population proportion is less than 0.75.  
μ = 17  μ ≠ 17  73.1323378744  There is sufficient statistical evidence to show the population mean is not 17.  
μ ≤ 119  μ > 119  21.3252630406  There is sufficient statistical evidence to show the population mean is greater than 119.  
Lefttailed test, reject Ho when z < 1.645.  Righttailed test, reject Ho when z > 1.645.  Twotailed test, reject Ho when z < 1.96 or z > 1.96. 
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. Rightclick in the cell to see these options.
Overview
Analyze data using inferential statistics for your previously defined survey questions.
Note: Be sure to complete Assessment 3 before completing this assessment.
By successfully completing this assessment, you will demonstrate your proficiency in the following course competencies and assessment criteria:
· Competency 3: Derive logical conclusions from inferential statistical procedures.
. Compute 95% confidence intervals correctly for multiple variables in a study.
. Derive appropriate conclusions based upon calculated confidence intervals for a study.
. Choose appropriate hypothesis tests based upon the context of the questions asked.
. Specify correct null and alternative hypotheses.
. Calculate hypothesis tests correctly for multiple questions in a study.
. Derive appropriate conclusions regarding hypotheses according to the results of hypothesis tests.
Required Resources
The following resources are required to complete the assessment.
·
Inferential Statistics to Analyze Data Template
.
Assessment Instructions
Note: Be sure to complete Assessment 3 before completing this assessment.
In Assessment 1, you documented typical responses to your survey, along with your question formulations. You did not know it at the time, but you were hypothesizing about the future survey results. Now that you have survey data, you can go back and apply the tools of inferential statistics to test your hypotheses.
For this assessment, analyze data using inferential statistics for your previously defined survey questions. Before you begin your analysis, note the following:
· Use the population proportions for questions 1–4 and the population means for questions 5–6. The sample statistics were calculated for each survey question in Assessment 2. Use this prior work to help complete this assessment. Keep in mind that you have already calculated the sample proportions for questions 1–4 as well as the sample means and standard deviations for questions 5–6.
· Use the Inferential Statistics to Analyze Data Template located in the Resources under the Required Resources heading. The template has two pages. Be sure to review each one carefully. The first page is the blank template that you will complete, and the second page is a completed example. Almost every type of situation is shown, so try to model your results after the ones shown.
Directions
1. Calculate a 95% confidence interval for each of your survey questions (1–6). Your final product should have six confidence intervals.
2. Perform a hypothesis test for each survey question (1–6). Your final product should have six hypothesis tests.
When determining the two hypotheses for each question, how do you know what to compare the population parameter to? Honestly, we do not know, but we can make an educated guess. First, since we have sample proportions and means to consider, remember that the sample statistics always support the alternative hypothesis. Why? Hypothesis testing always tries to reject the null hypothesis; thus, we must have some evidence (the sample statistics) that the alternative is correct. Outside of this requirement, feel free to use any logical value in your hypothesis test.
A few notes, however:
· We always think the alternative hypothesis is correct! This means the sample statistics (the sample proportion or mean) support the alternative hypothesis.
· You probably want to write the alternative hypothesis first. Then, the null hypothesis is just the opposite of the alternative.
· The two hypotheses must be the exact opposites of each other. We cannot put one value for the null and another for the alternative; that simply is not logical.
· For questions 1–4, we are using the sample proportion to estimate the population proportion. For questions 5–6, we are using the sample mean to estimate the population mean. Thus, we use different formulas for their confidence intervals and for their test statistics in the hypothesis tests.
Initial Survey Design Template
Alexander Chacon Ardite
07/25/2018
Instructions: Record your responses on the template below each question and upload this document as your assessment submission. Do not change any of the items on the template except to add or delete space.
1. What is the topic of your survey?
The topic of my survey is Evaluation healthcare access.
2. Why is the topic important? How might the results of the study be used in your personal or professional life?
The topic is important in that it will help in finding out the various ways in which the American citizens access healthcare. It will assist in exploring the potential benefits of and barriers to health care access among groups like senior citizens or lowincome families. Through this topic, it will be important in understanding the health care needs of specific populations such as those inhabiting the rural areas or inner cities. I think these results will help my personal life through determining the various challenges the American citizens they are encountering in the healthcare and the feedback from the patient of how the health care providers have been doing it. Also, I have had a passion for pursuing medicine in the near future, and I think this will help in finding the best areas to concentrate on in the nursing profession.
3
. What are the potential variables to be included in data gathering? You must include at least three variables that might be a part of your study. Write a minimum of one paragraph describing your potential variables.
The potential variables to be included in data gathering are age, gender, and location. These three potentials variables they are very critical in the data gathering in evaluation healthcare access. For instance, age in one of the potential variables in that it helps in making it possible for the obtaining of the information of the different generations of the American citizens and their view on the healthcare access. The gender is also another potential variable; this is through collecting data from this different American genders will help in acquiring information concerning the health care access. Through different gender, they will have different feedback on the health care access. Locality of the Americans will also be another potential variable when collecting data. The people from different areas will give information about the healthcare accessibility.
4. Define the population to be studied. Write 1–3 sentences describing your target population. Include specific characteristics including age range, gender, location, and any other identifiers that are unique and relevant to your population
The population to be studied is the diabetic population. The target population will be diabetic population will include characteristics like age range of 2540 years, both males and females, they are located in Texas. They are the best population because they have better information about the health care provider on their condition.
5. Explain why this is the best population for your study. Write at least one paragraph analyzing why you have chosen this population for your study.
It is the best population because it helps in finding out the best response on the feedback about the health care accessibility. There has been a notion that some of the lowincome earner they are neglected, and they fail to receive quality care, and this has been causing much pain to these patients. In addition, this will help in knowing the performance of the nurses in various hospital departments. It will assist in understanding the problem that the health care providers they have and also those which they need to improve. Lastly, the population will be the best because they have suffered from the condition and they will offer substantial information about the situation and potential barriers and benefits they have received from the healthcare access.
3
Designa Focused Survey Template
Alexander Chacon Ardite
07/
2
6/20
1
8
Instructions: Record your responses on the template below each question and submit your completed template to the appropriate assessment. Do not change any of the items on the template except to add or delete space.
1. State the population of your study. You should be able to do this in one to three sentences. Include specific characteristics including age range, gender, location, and any other identifiers that are unique and relevant to your population.
The population that I will study will include 50 parents that drop off or pick up their kids from school. I am carrying out this survey in Texas; I would like to find out which school is best for my son to attend.
2. Describe your sampling strategy. Write at least one paragraph describing your sampling strategy, how you would attempt to conduct your survey, and any potential issues that might affect your survey results. You should use one of the following techniques: random, stratified, cluster, systematic, or convenience. Your choice of strategy should be based on the purpose of your survey and your population.
My sampling strategy will be convenience. The reason I chose convenience is that not all parents are in a position to pick up or drop off their children’s at school. Some kids ride the bus from their pickup location to the school, so I would not be able to survey every parent. Therefore, while parents are waiting in the pickup line before school ends, I would study the first 40 cars to acquire their feedback. The issues I encounter in this survey strategy is that I would have to request permission from the school instead of walking up and down rows of cars to gather information. Then, I would move into issues of people not wanting to conduct the survey or be bothered by it. However, I do think that there are more than 40 pickups and dropping off their children any given day of the week at most wellinitiated learning institutions.
3
. Provide your survey questions, minimums, maximums, and typical responses: Follow the guidelines in the courseroom for the Designing a Focused Survey Assessment (u01a2).
Table 1
n/a
Binary
0.5
n/a
n/a
Binary
0.5
n/a
n/a
Binary
0.5
n/a
n/a
Quantitative
2
3
Question 
Question Type 
Typical Response 
Minimum 
Maximum 

1. Does the school schedule at least 2 parent/teacher meet and greet a year? 
Binary 
0.5 
n/a 

2. Do you agree with the learning strategies and content provided by teachers? 

3. Do you think/teacher communication at this school is frequent and sufficient? 

4. Does the school have an afterschool daycare? 

5. How many years has your kids(s) attended this school? 
Quantitative 
2  1 
3years 

6. On an average school year, how many field trips does the school offer? 
3 
2
>SurevyData
3 1 1 1 12 3
mary statistics for Questions 14
2 1 0 1 0 1 2Q2 Q3 Q4
parents
3 1 0 1 1 2 1said yes while
said no
4 1 0 1 1 1 285185
Mean 0.5185185185 Mean 0.5185185185 Mean
said yes while 26 said no
5 0 0 1 0 2 3Standard Error 0.06863
6 Standard Error 0.06863316 Standard Error
6 1 1 1 0 2 31 Median 1 Median 1 Median 1
agreed while
disagreed
0 1 0 1 2 2
1 Mode 1 Mode 1 Mode 1
866
Standard Deviation 0.50
6642 Standard Deviation 0.5043486642 Standard Deviation
6
8626
9 0 1 0 0 2 175751
Sample Variance 0.2543675751 Sample Variance 0.2543675751 Sample Variance
0 1 1 1 3 2
7
Kurtosis 2.0723919745 Kurtosis 2.0723919745 Kurtosis
28507
0 1 1 1 2 1
2
Skewness 0.0762598202 Skewness 0.0762598202 Skewness
9466
0 1 0 1 3 2
1 Range 1 Range 1 Range 1
0 Minimum 0 Minimum 0 Minimum 0
1 0 1 0 2 2
1 Maximum 1 Maximum 1 Maximum 1
16 1 1 1 1 3 3
54 Count 54 Count 54 Count 54
0 0 1 1 2 3
19 0 0 1 1 1 1
20 0 1 0 0 3 3
1 1 0 1 3 2
0 0 0 0 2 1
24 1 0 1 0 2 1
25 0 1 1 1 3 2
26 1 0 0 0 2 1
27 1 1 1 1 2 3
28 1 0 0 1 2 1
0 1 0 0 3 3
31 0 1 1 0 2 1
0 1 1 0 2 2
34 1 1 1 0 2 1
0 1 1 0 2 3
54
=
0 1 0 0 2 1
2
2
0 0 1 0 2 2 Mean 2.0925925926 Mean 1.9259259259
2 for Q5
2
Standard Error
2
2
1 0 0 1 2 2 Median 2 Median 2
1 0 0 1 1 1 Mode 2 Mode 2
1
1
Standard Deviation
569
3
3
12648
Sample Variance
44 0 0 0 1 2 2 KurtosisKurtosis
697
45 1 1 0 1 2 3 SkewnessSkewness
46 0 0 1 0 1 3 Range 2 Range 247 0 1 1 1 3 3 Minimum 1 Minimum 1
48 0 1 0 0 3 3 Maximum 3 Maximum 3
49 0 1 0 1 3 2 Sum
Sum
50 1 0 1 1 1 1 Count 54 Count 5451 1 0 0 0 1 2
52 1 1 0 1 2 2
0 1 0 1 3 2
1
30 65
24 48
28
2826
Q  1  Q2  Q3  Q  4  Q  5  Q  6  
0  Sum  
Q1  The sample of the survey was  54  
For Question one: 2  8  26  
Mean  0.5  18  51  0.5555555556  Q2:  28  
Standard Error  0.0686  33  16  31  0.068  25  50  13  Q3: 28 said yes while 26 said no  
Median  Q4:  30  24  
7  Mode  
Standard Deviation  0.504  34  42  43  48  0.50  15  9  
Sample Variance  0.254  36  0.25157  23  27  
10  Kurtosis  2.072  39  19  45  2.023  47  
11  Skewness  0.0762598  20  0.2300  46  
12  Range  
Minimum  
14  Maximum  
Count  
17  
Pie Charts for Questions 14  
21  
22  
29  
32  
35  Sample size was  
Q5  Q6  The mean  for Q5  2.0925925926  Mean for Question 6 =  1.9259259259  
37  Sample Median for Question 5=2  Sample Median for Q6 =  
38  Range is  Range for Q6 is  
0.0847098823  0.1085185543  Mode for Q5 is  Mode for Q6  
40  
41  Minimum value for Q5  Minimum Value for Q6  
0.6224879636  0.797  44  52  Maximum value for Q5  Maximum value for Q6  
0.387  49  0.6359189378  
0.3325581869  1.40472  65  
0.0607282331  0.1356826589  
113  104  
53  
Histograms For Questions 5 and 6  
Yes/No  Service  Counts  Number of years Kids attended the school  
Daycare  
No Daycare  
The table reports many counts on the school that offers AfterSchool daycare services  
A total of 54 parents were were sampled.  agreed that the school schedule atleast two teachers / parents meets and greets per year while the 26 remaining disagreed.  
of the parents are satisfied with the learning strategies and content provided by teachers.  of the total 54 thinks that teachers communication in the school is not sufficient.  
Most (30) reported that the school has after school daycare services. The mean of years for the kids who attended the school is 2.09 and for the field trips is 1.93 
Q1 1.0 1.0 1.0 1.0 0.0 1.0 0.0 1.0 0.0 0.0 0.0 0.0 0.0 1.0 0.0 1.0 0.0 1.0 0.0 0.0 1.0 0.0 1.0 1.0 0.0 1.0 1.0 1.0 0.0 1.0 0.0 0.0 1.0 1.0 0.0 1.0 0.0 0.0 1.0 1.0 1.0 1.0 1.0 0.0 1.0 0.0 0.0 0.0 0.0 1.0 1.0 1.0 0.0 0.0 Q2 1.0 0.0 0.0 0.0 0.0 1.0 1.0 0.0 1.0 1.0 1.0 1.0 1.0 0.0 0.0 1.0 0.0 0.0 0.0 1.0 1.0 0.0 1.0 0.0 1.0 0.0 1.0 0.0 1.0 1.0 1.0 1.0 0.0 1.0 1.0 1.0 1.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 1.0 0.0 1.0 1.0 1.0 0.0 0.0 1.0 1.0 0.0 Q3 1.0 1.0 1.0 1.0 1.0 1.0 0.0 0.0 0.0 1.0 1.0 0.0 0.0 1.0 1.0 1.0 1.0 0.0 1.0 0.0 0.0 0.0 1.0 1.0 1.0 0.0 1.0 0.0 0.0 1.0 1.0 1.0 0.0 1.0 1.0 0.0 0.0 1.0 1.0 0.0 0.0 0.0 1.0 0.0 0.0 1.0 1.0 0.0 0.0 1.0 0.0 0.0 0.0 0.0 Q4 0.0 0.0 1.0 1.0 0.0 0.0 1.0 1.0 0.0 1.0 1.0 1.0 1.0 0.0 1.0 1.0 1.0 1.0 1.0 0.0 1.0 0.0 1.0 0.0 1.0 0.0 1.0 1.0 0.0 0.0 0.0 0.0 1.0 0.0 0.0 1.0 0.0 0.0 0.0 1.0 1.0 0.0 0.0 1.0 1.0 0.0 1.0 0.0 1.0 1.0 0.0 1.0 1.0 1.0 Q5 2.0 1.0 2.0 1.0 2.0 2.0 2.0 2.0 2.0 3.0 2.0 3.0 3.0 2.0 2.0 3.0 2.0 1.0 1.0 3.0 3.0 2.0 2.0 2.0 3.0 2.0 2.0 2.0 3.0 2.0 2.0 2.0 2.0 2.0 2.0 3.0 2.0 2.0 2.0 2.0 1.0 2.0 2.0 2.0 2.0 1.0 3.0 3.0 3.0 1.0 1.0 2.0 3.0 2.0 Q6 3.0 2.0 1.0 2.0 3.0 3.0 2.0 1.0 1.0 2.0 1.0 2.0 1.0 2.0 1.0 3.0 3.0 2.0 1.0 3.0 2.0 1.0 2.0 1.0 2.0 1.0 3.0 1.0 3.0 1.0 1.0 2.0 2.0 1.0 3.0 3.0 1.0 2.0 2.0 2.0 1.0 3.0 1.0 2.0 3.0 3.0 3.0 3.0 2.0 1.0 2.0 2.0 2.0 1.0
Topquality papers guaranteed
100% original papers
We sell only unique pieces of writing completed according to your demands.
Confidential service
We use security encryption to keep your personal data protected.
Moneyback guarantee
We can give your money back if something goes wrong with your order.
Enjoy the free features we offer to everyone

Title page
Get a free title page formatted according to the specifics of your particular style.

Custom formatting
Request us to use APA, MLA, Harvard, Chicago, or any other style for your essay.

Bibliography page
Don’t pay extra for a list of references that perfectly fits your academic needs.

24/7 support assistance
Ask us a question anytime you need to—we don’t charge extra for supporting you!
Calculate how much your essay costs
What we are popular for
 English 101
 History
 Business Studies
 Management
 Literature
 Composition
 Psychology
 Philosophy
 Marketing
 Economics