Unit 3B Project(3)

xlsx

School

Bellevue University *

*We aren’t endorsed by this school

Course

215

Subject

Statistics

Date

Apr 3, 2024

Type

xlsx

Pages

Uploaded by BailiffApeMaster1116

We are starting to get into inference in Unit 3. Much of what you have learned in this course so far has led us this point. You'll find the Chapter 7 questions a bit more general. For Chapters 8 and 9 you will be asked to do more than just use Excel, as I'll want to ensure not only that you can use the confidence interval functions, but that you understand what you've found. Pay special attention to the instructions on each page. Some cells will ask for formulas while some boxes will ask for you to tell what you know based on the confidence interval you've found. Your work in Hawkes should set you up for success in this project. Keep in mind, however, that these text boxes don't have a "spell check" function. If you aren't so good with the spelling, you might want to compose your response in word then copy it over the text box. Be sure you are paying attention to what is expected in each cell. For instance, lets say I wanted to answer the question: We expect 32% of plain M&M's to be brown. In a sample of 1234 M&M's, we found 450 to be brown. Is this evidence that the M&M factory produces more than 32% brown M&M's? For our sample proportion (formula), I would enter =450/1234. Notice that the cell contains the solution to that division problem, but if I click on it, I can see that I entered 450/1234. For a formula we will enter = and then some value to be calculated. For expected proportion (data entry), I simply enter 0.32 from the question, as that is what we expect. For 1-p (formula), I use =1-N3, which gives me 0.68 as a solution. For sample size (data entry) I enter 1234, which is the size of the sample. Now, for z-score I am going to use all of the inputs I just entered. So intead of typing them all in again, I will simply put =(N2-N3)/SQRT(N3*N4/N5) and let Excel calulate the z-score for me. For probability (right tailed), which is a function, I will enter 1-NORM.S.DIST(N6,1). Remember a function uses something like NORM.S.DIST or STANDARDIZE or some other Excel function. Be sure you are utilizing the inputs, even if they aren't graded, and paying attention to what I will be looking for in each cell: formula, data entry or function. Also, recall that non-graded cells are locked so that all items to be graded are contained within the cell itself

A Sample Proportion (p-hat) 0.3646677 Formula Expected Proportion (p) 0.32 Data Entry 1 - p 0.68 Formula Sample Size (n) 1234 Data Entry 1 pt Z-Score 3.3637382 Formula 1 pt Probability (right tailed) 0.0003845 Function Inputs 1 pt

Word Count - Ch.7 Face value of Life Ins. - Ch.8 Pre-Test Scores Post-Test Scores 5 150000 65 80 5 150000 67 87 2 150000 70 91 11 150000 73 97 1 150000 70 89 5 150000 68 86 3 151000 72 85 8 152000 80 83 8 152000 70 89 4 153000 42 42 7 153000 75 85 3 155000 70 99 9 155000 65 92 5 158000 62 91 8 159000 57 83 10 159000 5 160000 5 160000 6 160000 6 160000 160000 163000 163000 163000 165000 165000 169000 168000 168000 172000 172000 172000 172000 172000 173000 174000 175000 175000 175000 176000 182000 182000 184000 184000

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

184000 187000 190000 195000 195000 195000 196000 200000 200000 200000 200000 200000 202000 202000

15 20 21 24 19 18 13 3 19 0 10 29 27 29 26

A Sample Proportion (p-hat) 0.431072 Formula Expected Proportion (p) 0.4 Data Entry 1 - p 0.6 Formula Sample Size (n) 457 Data Entry 1 pt Z-Score 1.355891 Formula 1 pt Probability (right tailed) 0.087567 Function 2 pts B Sample Mean (x-bar) 5.5 Data Entry Expected Mean (mu) 6.5 Data Entry Sample Stand. Dev (s) 2.627787 Given Sample Size (n) 20 Data Entry 1 pt Z-Score -1.701864 Formula 1 pt Probability (between) 0.911219 Function 2 pts Inputs 1 pt There is an 8.76% probability that the proportion of women athletes is greater than 40% Inputs 1 pt There is a 91.12% probability that the mean word length of the text book differs from the desired word length of 6.5 by less than 1. As always, be sure you've For these questions, you values. For instance, whe for you. When finding th entering everything in by A. Females participated there had been a stead Committee states that 40%, even with new sp recently added to the G advertising and marke Prior to the 2008 game pre-Olympic exhibition sample were women. I Find the probability th round your percentage B. Suppose that the edit length of 6.5 letters. The sample standard deviatio textbook differs from the decimal places in your co

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

e reviewed the Instructions tab first! u may use any values that you have already calculated to calculate future en finding "1-p" for question 1A, enter =1-C3 to let Excel calculate the value he z-score, use the values from the cells above it to calculate it, rather than y hand. d in every event at the 2012 Summer Olympic Games. Prior to 2012, dy increase in the female participation rate. The International Olympic t the female participation in the 2004 Summer Olympic Games was ports such as weight lifting, hammer throw, and modern pentathlon Games. Broadcasting and clothing companies wanted to change their eting strategies if the female participation increased at the next games. es, an independent sports expert arranged for a random sample of ns. The sports expert reported that 197 of 457 athletes in the random Is this strong evidence that the participation rate may have increased? hat the proportion of women athletes is greater than 40%. Correctly e to 2 decimal places in your conclusion sentence. tor of a new textbook was hoping that the book would have mean word e editor randomly selected 20 words from randomly selected pages. The on has been provided. Find the probability that the mean word length of the e desired 6.5 letters by less than 1 . Correctly round your percentage to 2 onclusion sentence.

Inputs A Sample Mean (x-bar) 12 Data Entry 2.1 Data Entry Sample Size (n) 84 Data Entry 1 pt Critical Value 1.644853627 Function 1 pt Margin of Error 0.376883313 Formula 1 pt Confidence Interval 11.62311669 12.3768833 (Formulas) (lower limit, upper limit) 2 pts Inputs B Sample Mean (x-bar) 171672.4138 Function 16851.66235 Function Sample Size (n) 58 Function 1 pt Critical Value 2.575829304 Function 1 pt Margin of Error 5699.619078 Formula 1 pt Confidence Interval 165972.7947 177372.033 (Formulas) (lower limit, upper limit) 2 pts Given Stand.Dev (σ or s) We can say with 90% confidence that Students spend between 11.6 and 12.4 hours studying. Since zero is not included in the interval and is less than the expected value of 14 hours we can assert that that students spend less than 14 hours per week studying. Given Stand.Dev (σ or s) We can say with 99% confidence that the average face value of an individuals life insurance policy is between $165,972.80 & $177,372.03. Since zero is not included in this interval we can say this is accurate. We must tr deviation o questions b A. Profess students st hours of st interval for that the po Correctly r interpretati average, sp B. Jake, fro individual l sample is i interval for round your

reat data differently based on if we know the population standard or not. Be sure you chose the correct method for each of the below dealing with confidence intervals for means. (5 pts each) sor Brehm wants to estimate how many hours per week her tudy. A simple random sample of 84 students had a mean of 12 tudy time per week. Construct and interpret a 90% confidence r the mean number of hours a student studies per week. Assume opulation standard deviation is known to be 2.1 hours per week. round your results to the nearest tenth (one decimal place) in the tion of your interval. Does the data suggest that students, on pend less than 14 hours per week studying? Explain. om State Farm, wanted to know the mean face value of an life insurance policy. The data he collected from his random in your Data Set tab. Construct and interpret a 99% confidence r mean face value of life insurance policies at State Farm. Correctly r results to the nearest dollar in the interpretation of your interval.

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Inputs A Number favorable (x) 18 Formula Sample Size (n) 150 Data Entry p-hat 0.12 Data Entry 1 - (p-hat) 0.88 Formula 1 pt Critical Value 1.9599639845 Function 1 pt Margin of Error 0.0520037211 Formula 1 pt Confidence Interval 0.0679962789 0.1720037211 (Formulas) (lower limit, upper limit) 2 pts Inputs B Number favorable (x) 87 Data Entry Sample Size (n) 279 Data Entry (p-hat) 0.311827957 Formula 1 - (p-hat) 0.688172043 Formula 1 pt Critical Value 1.644853627 Function 1 pt Margin of Error 0.0456174697 Formula 1 pt Confidence Interval 0.2662104873 0.3574454267 (Formulas) (lower limit, upper limit) 2 pts With 95% Confidence, we estimate that between 6.7% and 17.2% of all faculty can speak spanish With 90% Confidence, we estimate that between 26.6% and 35.7% of all Bellevue University Students check their email on a regular basis For these questions, we ar Remember that the differe percent of the total. (5 pts A. Out of 150 faculty mem Spanish. Construct and int members that can speak S tenth of a percent in your B. A survey of 279 random only 87 checked their cam interpret a 90% confidenc university that check their the nearest tenth of a perc

re going to find a confidence interval for proportion data. ence is that proportion data is always computed as the s each) mbers at Bellevue University, 12% said they can speak terpret a 95% interval for the proportion of all faculty Spanish. Correctly round your results to the nearest conclusion sentence. mly selected students at Bellevue University showed that mpus email account on a regular basis. Construct and ce interval for the percentage of students at the r email on a regular basis. Correctly round your results to rcent in your conclusion sentence.

Inputs A Point Estimate 18.2 Function Standard Dev (s) 8.8009739721 Function Sample Size (n) 15 Function 1 pt Critical Value 1.7613101358 Function 1 pt Margin of Error 4.0024041614 Formula 1 pt Confidence Interval 14.197595839 22.2024042 (Formulas) (lower limit, upper limit) 2 pts Inputs B p-hat 1 (Graduates) 0.7567567568 Formula 1 - (p-hat 1) 0.2432432432 Formula Sample Size (n1) 37 Data Entry p-hat 2 (Dropouts) 0.6153846154 Formula 1 - (p-hat 2) 0.3846153846 Formula Sample Size (n2) 39 Data Entry Point Estimate 0.1413721414 Formula 1 pt Critical Value 1.9599639845 Function 1 pt Margin of Error 0.2059726139 Formula 1 pt Confidence Interval -0.0646004725 0.34734476 (lower limit, upper limit) 2 pts We can say with 90% Confidence that the average test scores of students increased between 14.2 and 22.2 points. Since Zero (0) was not incleded in the interval we can assert that Their Teaching methods are effective. We can say with 95% Confidence that the difference in dropout rates are between -6.5% and 34.7%. Since zero (0) is part of the interval we can NOT say with any certainty that Kids involved in sports impacts dropout rates. For your final qu determining wha or possibly the m proportions) and related. Quite oft there are other i interval for each each) A. Professor Bre test at the begin selected student interpret a 90% teaching method Brehm's teachin decimal place) in B. A high school One factor of int out of high scho children. She the Construct and in school graduate is a difference b nearest tenth of

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

uestions in this project we will be comparing two populations. We are interested in at difference we can expect between the mean of two samples, the proportion of two samples mean difference between two samples. It depends on the kind of data we have (means or d whether or not the data is paired. If data is paired it means that the two sets of data are ften we find this in an experiment with data from before and after a treatment is applied, but instances where data sets are not independent, as well. Choose the appropriate type of h instance and fill in the colored boxes to compute the appropriate confidence interval. (5 pts ehm wants to know if her teaching methods increase student learning. She administers a pre- nning of the term and a post-test at the end of the term. The results from 15 randomly ts are given in your data set under Pre-Test Scores and Post-Test Scores. Construct and confidence interval for the true mean difference between the scores to determine if her ds increase student knowledge of the course material. Does this data suggest that Professor ng methods are effective? Correctly round your results to the nearest tenth of a percent (one n the interpretation of your interval. l counselor is interested in determining factors that contribute to high school drop out rates. terest to her is whether kids who are involved in team sports as children are less likely to drop ool. She surveys 37 high school graduates and finds that 28 were involved in team sports as en surveys 39 high school dropouts and finds that 24 were involved in team sports as children. nterpret a 95% confidence interval for the true difference between the proportions of high es and dropouts who participated in team sports as children. Does this data suggest that there between these proportions at this level of confidence? Correctly round your results to the f a percent (one decimal place) in the intepretation of your interval.