APA FORMAT ACTIVE VOICE TIMES ROMAN 12 FREE OF GRAMMATICAL SPELLING SENTENCE STRUCTURE ERRORS FIRM GRASP OF ENGLISH LANGUAGE ZERO USE OF CONVERSATIONAL ENGLISH IN TEXT CITATIONS REFERENCE PAGE 100% PLAGIARISM FREEGrading RubricA=4=MasteryAll problems solved correctlyComplete and detailed steps are provided to explain how to solve the problem.Explanations demonstrate a mastery of understanding of the statistical concepts and terminology.All variables, equations, and expression are properly formattedCompetencyDemonstrate the use of the normal distribution, the standard normal distribution, and the central limit theorem for calculating areas under the normal curve and exploring these concepts in real life applications.ScenarioFrank has only had a brief introduction to statistics when he was in high school 12 years ago, and that did not cover inferential statistics. He is not confident in his ability to answer some of the problems posed in the course.As Frank's tutor, you need to provide Frank with guidance and instruction on a worksheet he has partially filled out. Your job is to help him understand and comprehend the material. You should not simply be providing him with an answer as this will not help when it comes time to take the test. Instead, you will be providing a step-by-step breakdown of the problems including an explanation on why you did each step and using proper terminology.What to SubmitTo complete this assignment, you must first download the word document, and then complete it by including the following items on the worksheet:Incorrect AnswersCorrect any wrong answers. You must also explain the error performed in the problem in your own words.Partially Finished WorkComplete any partially completed work. Make sure to provide step-by-step instructions including explanations.Blank QuestionsShow how to complete any blank questions by providing step-by-step instructions including explanations.Your step-by-step breakdown of the problems, including explanations, should be present within the word document provided. You must also include an Excel workbook which shows all your calculations performed.

10.1.2Table #10.1.6 contains the value of the house and the amount of rental income in a year that the house brings in ("Capital and rental," 2013). Create a scatter plot and find a regression equation between house value and rental income. Then use the regression equation to find the rental income a house worth $230,000 and for a house worth $400,000. Which rental income that you calculated do you think is closer to the true rental income? Why?Table #10.1.6: Data of House Value versus Rental Value Rental Value Rental Value Rental Value Rental 81000 6656 77000 4576 75000 7280 67500 6864 95000 7904 94000 8736 90000 6240 85000 7072 121000 12064 115000 7904 110000 7072 104000 7904 135000 8320 130000 9776 126000 6240 125000 7904 145000 8320 140000 9568 140000 9152 135000 7488 165000 13312 165000 8528 155000 7488 148000 8320 178000 11856 174000 10400 170000 9568 170000 12688 200000 12272 200000 10608 194000 11232 190000 8320 214000 8528 208000 10400 200000 10400 200000 8320 240000 10192 240000 12064 240000 11648 225000 12480 289000 11648 270000 12896 262000 10192 244500 11232 325000 12480 310000 12480 303000 12272 300000 12480 10.1.4The World Bank collected data on the percentage of GDP that a country spends on health expenditures ("Health expenditure," 2013) and also the percentage of woman receiving prenatal care ("Pregnant woman receiving," 2013). The data for the countries where this information are available for the year 2011 is in table #10.1.8. Create a scatter plot of the data and find a regression equation between percentage spent on health expenditure and the percentage of woman receiving prenatal care. Then use the regression equation to find the percent of woman receiving prenatal care for a country that spends 5.0% of GDP on health expenditure and for a country that spends 12.0% of GDP. Which prenatal care percentage that you calculated do you think is closer to the true percentage? Why? Table #10.1.8: Data of Heath Expenditure versus Prenatal Care HealthExpenditure(% of GDP) PrenatalCare (%) 9.6 47.9 3.7 54.6 5.2 93.7 5.2 84.7 10.0 100.0 4.7 42.5 4.8 96.4 6.0 77.1 5.4 58.3 4.8 95.4 4.1 78.0 6.0 93.3 9.5 93.3 6.8 93.7 6.1 89.8 For each problem, state the random variables. Also, look to see if there are any outliers that need to be removed. Do the correlation analysis with and without the suspected outlier points to determine if their removal affects the correlation. The data sets in this section are in section 10.1.10.2.2Table #10.1.6 (from problem 10.1.2) contains the value of the house and the amount of rental income in a year that the house brings in ("Capital and rental," 2013). Find the correlation coefficient and coefficient of determination and then interpret both.10.2.4The World Bank collected data on the percentage of GDP that a country spends on health expenditures ("Health expenditure," 2013) and also the percentage of woman receiving prenatal care ("Pregnant woman receiving," 2013). The data for the countries where this information is available for the year 2011 are in table #10.1.8 (from problem 10.1.4). Find the correlation coefficient and coefficient of determination and then interpret both.For each problem, state the random variables. The data sets in this section are in the homework for section 10.1 and were also used in section 10.2. If you removed any data points as outliers in the other sections, remove them in this sections homework too.10.3.2Table #10.1.6 (from problem 10.1.2) contains the value of the house and the amount of rental income in a year that the house brings in ("Capital and rental," 2013).a.) Test at the 5% level for a positive correlation between house value and rental amount.b.) Find the standard error of the estimate.c.) Compute a 95% prediction interval for the rental income on a house worth $230,000.10.3.4The World Bank collected data on the percentage of GDP that a country spends on health expenditures ("Health expenditure," 2013) and also the percentage of woman receiving prenatal care ("Pregnant woman receiving," 2013). The data for the countries where this information is available for the year 2011 are in table #10.1.8 (from problem 10.1.4).a.) Test at the 5% level for a correlation between percentage spent on health expenditure and the percentage of woman receiving prenatal care.b.) Find the standard error of the estimate.c.) Compute a 95% prediction interval for the percentage of woman receiving prenatal care for a country that spends 5.0 % of GDP on health expenditure.In each problem show all steps of the hypothesis test. If some of the assumptions are not met, note that the results of the test may not be correct and then continue the process of the hypothesis test.11.1.2Researchers watched groups of dolphins off the coast of Ireland in 1998 to determine what activities the dolphins partake in at certain times of the day ("Activities of dolphin," 2013). The numbers in table #11.1.6 represent the number of groups of dolphins that were partaking in an activity at certain times of days. Is there enough evidence to show that the activity and the time period are independent for dolphins? Test at the 1% level. Table #11.1.6: Dolphin Activity Activity Period RowTotal Morning Noon Afternoon Evening Travel 6 6 14 13 39 Feed 28 4 0 56 88 Social 38 5 9 10 62 ColumnTotal 72 15 23 79 189 11.1.4A person’s educational attainment and age group was collected by the U.S. Census Bureau in 1984 to see if age group and educational attainment are related. The counts in thousands are in table #11.1.8 ("Education by age," 2013). Do the data show that educational attainment and age are independent? Test at the 5% level.Table #11.1.8: Educational Attainment and Age Group Education Age Group RowTotal 25-34 35-44 45-54 55-64 >64 Did not completeHS 5416 5030 5777 7606 13746 37575 CompletedHS 16431 1855 9435 8795 7558 44074 College 1-3year 8555 5576 3124 2524 2503 22282 College 4 or more years 9771 7596 3904 3109 2483 26863 ColumnTotal 40173 20057 22240 22034 26290 130794 In each problem show all steps of the hypothesis test. If some of the assumptions are not met, note that the results of the test may not be correct and then continue the process of the hypothesis test.11.2.4In Africa in 2011, the number of deaths of a female from cardiovascular disease for different age groups are in table #11.2.6 ("Global health observatory," 2013). In addition, the proportion of deaths of females from all causes for the same age groups are also in table #11.2.6. Do the data show that the death from cardiovascular disease are in the same proportion as all deaths for the different age groups? Test at the 5% level.Table #11.2.6: Deaths of Females for Different Age Groups Age 5-14 15-29 30-49 50-69 Total Cardiovascular Frequency 8 16 56 433 513 All Cause Proportion 0.10 0.12 0.26 0.52 11.2.6A project conducted by the Australian Federal Office of Road Safety asked people many questions about their cars. One question was the reason that a person chooses a given car, and that data is in table #11.2.8 ("Car preferences," 2013).Table #11.2.8: Reason for Choosing a Car Safety Reliability Cost Performance Comfort Looks 84 62 46 34 47 27 Do the data show that the frequencies observed substantiate the claim that the reason for choosing a car are equally likely? Test at the 5% level.

A1 Hotels operates luxury hotels throughout the world. Recently, motivated by some incidents that appeared in the news, they have been concerned about the quality of service. The company has been giving the following survey to its clients after their stay:How would you rate the quality of your room? Select one.Good(G), Poor(P)How would you rate the quality of your food? Select one.Good(G), Poor(P)How would you rate the quality of your service? Select one.Good (G), Poor(P)Any customer who answered “Poor” to at least one of the three questions up above is considered to be “dissatisfied.” Traditionally, 40% of customers have been dissatisfied.A1 Hotels would like to study customer satisfaction. Therefore, 200 survey responses were recently chosen at random for analysis. The complete data set is in the file named Hotels.Managerial ReportPrepare a report (see below) for A1 Hotels that summarizes your assessment of customer satisfaction. Be sure to include the following seven items in your report.To summarize the data, compute the proportion of all clients thatAnswered “Poor” to room quality.Answered “Poor” to food quality.Answered “Poor” to service quality.Develop the 92% confidence interval for the proportion of all recent clients that were “dissatisfied.” What is the margin of error? What are the lower (or left) and upper (or right) endpoints of the confidence interval? Interpret your results.Develop the 92% confidence interval for the proportion of all recent clients who answered “Poor” to room quality. What is the margin of error? What are the lower (or left) and upper (or right) endpoints of the confidence interval? Interpret your results.Develop the 92% confidence interval for the proportion of all recent clients who answered “Poor” to food quality. What is the margin of error? What are the lower (or left) and upper (or right) endpoints of the confidence interval? Interpret your results.Develop the 92% confidence interval for the proportion of all recent clients who answered “Poor” to service quality. What is the margin of error? What are the lower (or left) and upper (or right) endpoints of the confidence interval? Interpret your results.Conduct a hypothesis test (using either the p-Value Approach or the Critical Value Approach) to determine if the proportion of all recent clients is more dissatisfied than the traditional level of dissatisfaction. Use α = 0.08. Do not forget to include the correctly worded hypotheses and show all the steps required to conduct the hypothesis test.What advice would you give to A1 Hotels based upon your analysis of the data? What is the magnitude of the issue? How can this study be improved?Write a report that adheres to the Written Assignment Requirements under the heading “Expectations for CSU-Global Written Assignments” found in the CSU-Global Guide to Writing and APA Requirements (Links to an external site.)Links to an external site.. As with all written assignments at CSU-Global, you should have in-text citations and a reference page. An example paper is provided in the MTH410 Guide to Writing with Statistics. (link provided in the Modules tab)Submit your Excel file in addition to your report.Requirements:Paper must be written in third person.Your paper should be four to five pages in length (counting the title page and references page) and cite and integrate at least one credible outside source. The CSU-Global Library (Links to an external site.)Links to an external site. is a great place to find resources.Include a title page, introduction, body, conclusion, and a reference page.The introduction should describe or summarize the topic or problem. It might discuss the importance of the topic or how it affects you or society as a whole, or it might discuss or describe the unique terminology associated with the topic.The body of your paper should answer the questions posed in the problem. Explain how you approached and answered the question or solved the problem, and, for each question, show all steps involved. Be sure this is in paragraph format, not numbered answers like a homework assignment.The conclusion should summarize your thoughts about what you have determined from the data and your analysis, often with a broader personal or societal perspective in mind. Nothing new should be introduced in the conclusion that was not previously discussed in the body paragraphs.Include any tables of data or calculations, calculated values, and/or graphs associated with this problem in the body of your assignment.Document formatting, citations, and style should conform to the CSU-Global Virtual Library CSU-Global Guide to Writing and APA: Introduction (Links to an external site.)Links to an external site.. A short summary containing much that you need to know about paper formatting, citations, and references is contained in the New Sample APA Paper (Links to an external site.)Links to an external site.. In addition, information in the CSU-Global Virtual Library under the Writing Center/APA Resources tab (Links to an external site.)Links to an external site. has many helpful areas (Writing Center, Writing Tips, Template & Examples/Papers & Essays, and others).