In Born togetherReared apart: the Landmark Minnesota twin study (2012), Nancy Segal discusses the efforts of research psychologists at the University of Minnesota to understand similarities and differences between twins by studying sets of twins who were raised separately. The Excel Online file below contains critical reading SAT scores for several pairs of identical twins (twins who share all of their genes), one of whom was raised in a family with no other children (no siblings) and one of whom was raised in a family with other children with siblings). Construct a spreadsheet to answer the following questions Open spreadsheet a. What is the mean difference between the critical reading SAT scores for the twins raised with no siblings and the twins raised with siblings? (to 2 decimals) b. Provide a 90% confidence interval estimate of the mean difference between the critical reading SAT scores for the twins raised with no siblings and the twins raised with siblings > (to 2 decimals) c. Conduct a hypothesis test of equality of the critical reading SAT scores for the twins raised with no siblings and the twins raised with siblings. p-value is (to 4 decimals) The domestic airfare for business travel for the current year and the previous year was reported. A sample of 12 flights with their domestic airfares shown for both years is contained in the Excel Online file below. Construct a spreadsheet to answer the following questions At G = .01, what is your conclusion? that there is a difference between the mean scores for the no sibling and with sibling groups, X Open spreadsheet a. Formulate the hypotheses and test for a significant increase in the mean domestic airfare for business travel for the one year period H- H- What are the t-value, degrees of freedom, and E-value (to 4 decimals) Degrees of freedom Suppose that you are responsible for making arrangements for a business convention and that you have been charged with choosing a city for the convention that has the least expensive rooms. You have narrowed your choices to Atlanta and Houston. The table containing samples of prices for rooms in Atlanta and Houston is provided in the Excel Online file below. Construct a spreadsheet to answer the following questions. Because considerable historical data on the prices of rooms in both cities are available, the population standard deviations for the prices can be assumed to be $18.11 in Atlanta and $29.21 in Houston. p-value (to 4 decimals) Using a .05 level of significance, what is your conclusion? that there has been a significance increase in business travel airfares over the one-year period b. What is the sample mean domestic airfare for business travel for each year? Current Year: $ (to 2 decimals) (to 2 decimals) X Previous Year: $ c. What is the percentage change in the airfare for the one-year period? % (to 2 decimals) Open spreadsheet Based on the sample data, can you conclude that the mean price of a hotel room in Atlanta is lower than one in Houston? Use a=.05 and null hypothesis is Ho : Atlanta - Houston 20. z-value (to 2 decimals) (to 4 decimals) p-value Reject the null hypothesis? We that the mean price of a hotel room in Atlanta is lower than the mean price of a hotel room in Houston. In Born togetherReared apart: the Landmark Minnesota twin study (2012), Nancy Segal discusses the efforts of research psychologists at the University of Minnesota to understand similarities and differences between twins by studying sets of twins who were raised separately. The Excel Online file below contains critical reading SAT scores for several pairs of identical twins (twins who share all of their genes), one of whom was raised in a family with no other children (no siblings) and one of whom was raised in a family with other children with siblings). Construct a spreadsheet to answer the following questions Open spreadsheet a. What is the mean difference between the critical reading SAT scores for the twins raised with no siblings and the twins raised with siblings? (to 2 decimals) b. Provide a 90% confidence interval estimate of the mean difference between the critical reading SAT scores for the twins raised with no siblings and the twins raised with siblings > (to 2 decimals) c. Conduct a hypothesis test of equality of the critical reading SAT scores for the twins raised with no siblings and the twins raised with siblings. p-value is (to 4 decimals) The domestic airfare for business travel for the current year and the previous year was reported. A sample of 12 flights with their domestic airfares shown for both years is contained in the Excel Online file below. Construct a spreadsheet to answer the following questions At G = .01, what is your conclusion? that there is a difference between the mean scores for the no sibling and with sibling groups, X Open spreadsheet a. Formulate the hypotheses and test for a significant increase in the mean domestic airfare for business travel for the one year period H- H- What are the t-value, degrees of freedom, and E-value (to 4 decimals) Degrees of freedom Suppose that you are responsible for making arrangements for a business convention and that you have been charged with choosing a city for the convention that has the least expensive rooms. You have narrowed your choices to Atlanta and Houston. The table containing samples of prices for rooms in Atlanta and Houston is provided in the Excel Online file below. Construct a spreadsheet to answer the following questions. Because considerable historical data on the prices of rooms in both cities are available, the population standard deviations for the prices can be assumed to be $18.11 in Atlanta and $29.21 in Houston. p-value (to 4 decimals) Using a .05 level of significance, what is your conclusion? that there has been a significance increase in business travel airfares over the one-year period b. What is the sample mean domestic airfare for business travel for each year? Current Year: $ (to 2 decimals) (to 2 decimals) X Previous Year: $ c. What is the percentage change in the airfare for the one-year period? % (to 2 decimals) Open spreadsheet Based on the sample data, can you conclude that the mean price of a hotel room in Atlanta is lower than one in Houston? Use a=.05 and null hypothesis is Ho : Atlanta - Houston 20. z-value (to 2 decimals) (to 4 decimals) p-value Reject the null hypothesis? We that the mean price of a hotel room in Atlanta is lower than the mean price of a hotel room in Houston