Question

In: Math

In the Excel data file, the tab labeled Question 1 contains data on the number of...

  1. In the Excel data file, the tab labeled Question 1 contains data on the number of times boys and girls raise their hands in class. Conduct the t-test: Two-Sample Assuming Equal Variances.
  2. Males 9,8,4,9,3,8,10,8,9,10,7,6,12
  3. Females 3,5,1,2,6,4,3,6,7,9,7,3,7,6,8,8

a. What is the null hypothesis?

b. What is the research hypothesis?

c. Why run a Two-Sample Assuming Equal Variances t-test?

d. Interpret the findings. What are the results of the hypothesis test? Can you reject the null hypothesis?

Solutions

Expert Solution

Assume that both the populations of males and females who raise their hands are distributed normally.

a) Null hypothesis

b) Research hypothesis

c) We run a two-sample t-test assuming equal variances because we assume that there is not much spread among the students in a class raising their hands. A t-test is appropriate because the male and female populations are independent of each other and homoscedastic.

d) we can estimate the population variance from the sample pooled variance since we assume that the populations are homoscedastic.

, under the null hypothesis. Here, S= pooled variance

9 3 1.159763 5.347656
8 5 0.005917 0.097656
4 1 15.39053 18.59766
9 2 1.159763 10.97266
3 6 24.23669 0.472656
8 4 0.005917 1.722656
10 3 4.313609 5.347656
8 6 0.005917 0.472656
9 7 1.159763 2.847656
10 9 4.313609 13.59766
7 7 0.852071 2.847656
6 3 3.698225 5.347656
12 7 16.6213 2.847656
6 0.472656
8 7.222656
8 7.222656
total 103 85 72.92308 85.4375
average 7.923077 5.3125

so,

and and

Hence,

To test the hypothesis, test statistic is:

From sample information, T= 7.731436

Critical value = =

We reject the null hypothesis at 5% level of significance, since |T| > critical value.

So,we conclude that there is a difference in the number of males and females who raise their hand in class.


Related Solutions

The data set for this question set (Tab Q1 in the Excel data file) comes from...
The data set for this question set (Tab Q1 in the Excel data file) comes from a research project that tracks the elderly residents in a community to monitor their cognitive function and general health. Based on the literature, education is considered a protective factor against dementia, and memory decline is usually the first sign of dementia. So the researchers would like to know whether education level (measured in number of years of formal schooling) is correlated with memory function...
The Excel file Burglaries contains data on the number of burglaries before and after a Citizen...
The Excel file Burglaries contains data on the number of burglaries before and after a Citizen Police program. Apply the Descriptive Statistics tool to these data. Does Chebyshev’s theorem hold for the number of monthly burglaries before and after the citizen-police program? Data : Before Citizen-Police Program Month Monthly burglaries 1 60 2 44 3 37 4 54 5 59 6 69 7 108 8 89 9 82 10 61 11 47 12 72 13 87 14 60 15 64...
Using the data in the Excel file under the tab Problem1, develop a regression equation for...
Using the data in the Excel file under the tab Problem1, develop a regression equation for a country’s lung cancer death rate based on cigarette consumption. Is this a good regression model?  Why or why not? If Cigarette Consumption was 725, what would you predict the Lung Cancer Death Rate to be? Using your regression model, what is the Residual Value for Finland? Do you think there are any outliers in the model?  If so, what would you do with them? Country...
1. The Excel file “FoodBank” contains the number of pounds of food donated to a local...
1. The Excel file “FoodBank” contains the number of pounds of food donated to a local food bank for each of the past 30 weeks. For planning purposes, the manager of the food bank would like a forecasting model to predict future donations. Create simple exponential smoothing models in Excel using α=0.2, α=0.5, and α=0.8. (Recall that damping factor = 1-α.) Week Donations 1 260 2 264 3 268 4 242 5 269 6 261 7 267 8 256 9...
Question 2. Go to the Blackboard and download the MS excel file, ‘stock_return.xlsx’. It contains a...
Question 2. Go to the Blackboard and download the MS excel file, ‘stock_return.xlsx’. It contains a year of monthly stock price data of Amazon, Pfizer, and S&P 500 (Market Index). Using the data, answer the following questions. (50 points) (1) Compute the monthly return of Amazon and Pfizer. You should get 12 monthly returns for each. To get a monthly return, you need to use previous month’s stock price. For example, Amazon’s stock return of 2018-01 will be [(Stock price...
On Moodle, you will find a file labelled “Data for Question 4 Assignment 1”. It contains...
On Moodle, you will find a file labelled “Data for Question 4 Assignment 1”. It contains data on past students in this course. Under Midterm is information on whether past studentsgot an A grade (A−, A, A+) an F or D grade (D is a passing grade but most students need aC− for it to count towards their program) or Other (any grade in between). Under FinalExam is information on whether students got a D or F grade or anything...
The Excel file Stock Data contains monthly data for several stocks and the S&P 500 Index...
The Excel file Stock Data contains monthly data for several stocks and the S&P 500 Index (i.e., the market). Assume the risk free rate of return is 2.5%. Compute the cost of equity (required rate of return) for Cin using the classic CAPM. Compute the Weighted Average Cost of Capital (WACC) for Cin using the classic CAPM if the corporate tax rate is 20%, the cost of debt is 15% and the capital structure is: 75% equity and 25% debt....
The Excel file Stock Data contains monthly data for several stocks and the S&P 500 Index...
The Excel file Stock Data contains monthly data for several stocks and the S&P 500 Index (i.e., the market). Compute Beta for NT and the S & P 500 using the Covariance/Variance relationship. Compute Beta for NT and the S & P 500 using the EXCEL slope function. Compute the equation: Ri= ai + biRMKT for NT. Compute R2 for this equation. Compute the t-statistic for a. Is the t-statistic for a Significant or Not Significant? Compute the t-statistic for...
SHOW YOUR WORK not only the solutions, on worksheet tab in Excel file A fully amortizing...
SHOW YOUR WORK not only the solutions, on worksheet tab in Excel file A fully amortizing mortgage loan is made for $80,000 at 6 percent interest for 25 years. Payments are to be made monthly. Calculate: a. Monthly payments. b. Interest and principal payments during month 1. c. Total principal and total interest paid over 25 years. d. The outstanding loan balance if the loan is repaid at the end of year 10. e. Total monthly interest and principal payments...
(Please show excel working tab) Question 1 (25 marks) Design an Excel financial model that can...
(Please show excel working tab) Question 1 Design an Excel financial model that can help to answer the following parts (part 1 - 3). 5 marks will be allocated for the presentation and clarity of your model (e.g., if there are clear headings, clear arrangement for input cells, appropriate use of colors, have some degree of flexibility, generate warning messages for wrong user inputs, etc.). Part 1 Suppose you receive $100 at the end of each year for the next...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT