Question

In: Statistics and Probability

Use it and Excel to answer this question. It contains Assignment 1 marks for two past...

Use it and Excel to answer this question. It contains Assignment 1 marks for two past sections of this course

Treat it as a random sample. Perform a hypothesis test to determine if the two sample means are equal. Use α = 0.10.

Section A Section B
15 16
26 52
52 55
53 57.5
54 58
56.5 60
61 61
61.5 70
63 70
66 71
66 72
66.5 73
69 74.5
71 75
77 75.5
77 76
78 77
79 81
81 85
86 85.5
87 86
90 88
90 88.5
91 91
91 93
94
95
96
98
98
99.5
100

Solutions

Expert Solution

Ho :   µ1 - µ2 =   0              
Ha :   µ1-µ2 ╪   0              
                      
Level of Significance ,    α =    0.1              
                      
Sample #1   ---->   sample 1              
mean of sample 1,    x̅1=   68.30              
standard deviation of sample 1,   s1 =    19.13              
size of sample 1,    n1=   25              
                      
Sample #2   ---->   sample 2              
mean of sample 2,    x̅2=   77.25              
standard deviation of sample 2,   s2 =    18.08              
size of sample 2,    n2=   32              
                      
difference in sample means =    x̅1-x̅2 =    68.3000   -   77.3   =   -8.95
                      
pooled std dev , Sp=   √([(n1 - 1)s1² + (n2 - 1)s2²]/(n1+n2-2)) =    N/A              
std error , SE =    Sp*√(1/n1+1/n2) =    4.9846              
                      
t-statistic = ((x̅1-x̅2)-µd)/SE = (   -8.9500   -   0   ) /    4.98   = - 1.796
                      
Degree of freedom, DF=   n1+n2-2 =    50          

   
t-critical value , t* =       1.6759 (excel formula =t.inv(α/2,df)      

   
Decision:   | t-stat | < | critical value |, so, Reject Ho          

conclusion : there is not enough evidence to conclude the   two sample means are equal
  


Related Solutions

Use the data and Excel to answer this question. It contains the United States Census Bureau’s...
Use the data and Excel to answer this question. It contains the United States Census Bureau’s estimates for World Population from 1950 to 2014. You will find a column of dates and a column of data on the World Population for these years. Generate the time variable t. Then run a regression with the Population data as a dependent variable and time as the dependent variable. Have Excel report the residuals. (a) Based on the ANOVA table and t-statistics, does...
Use the data and Excel to answer this question. It contains the United States Census Bureau’s...
Use the data and Excel to answer this question. It contains the United States Census Bureau’s estimates for World Population from 1950 to 2014. You will find a column of dates and a column of data on the World Population for these years. Generate the time variable t. Then run a regression with the Population data as a dependent variable and time as the dependent variable. Have Excel report the residuals. (a) Based on the ANOVA table and t-statistics, does...
This is a short answer assignment. Each question carries 10 marks. 1. Explain any TWO (2)...
This is a short answer assignment. Each question carries 10 marks. 1. Explain any TWO (2) advantages of subsidiary (delegated) legislation. 2. Describe the jurisdiction of the Federal Court in Malaysia. 3. Explain any THREE (3) ways how a proposal can be revoked as provided in Contracts Act 1950. 4. In relation to Contracts Act 1950, explain what is meant by “consideration need not be adequate but must be sufficient”. 5. Explain any THREE (3) exceptions to the nemo dat...
Excel Assignment 2 Direction: Use Microsoft Excel to answer the following three questions (Excel Instructions are...
Excel Assignment 2 Direction: Use Microsoft Excel to answer the following three questions (Excel Instructions are provided in previous assignment) 1. An Economist was interested in sex differences in the number of books a person reads (see file: Number of Books). Two random samples were taken, one of men and the other, and the number of books read during the last month was recorded. Is there a difference with respect to the number of books read by females and males?...
INSTRUCTIONS: 1. The Assignment contains 3 questions (20 MARKS Each) with a total of 60 MARKS...
INSTRUCTIONS: 1. The Assignment contains 3 questions (20 MARKS Each) with a total of 60 MARKS 2. All questions must be answered electronically (No hand-written submissions) 3. Draw all the required diagrams using a drawing software application/tool e.g. Microsoft Visio. (No snapshots/screengrabs will be accepted). You can use one of the CASE tools you use in OOSAD if you wish. 4. Submit a Portable Document Format (PDF) as your final submission. No other file QUESTION ONE 1. Briefly describe the...
QUESTION 1 (10 Marks- 5 each)- This question contains two sub questions a and b. Describe...
QUESTION 1 (10 Marks- 5 each)- This question contains two sub questions a and b. Describe five requirements of the COBIT framework. Compare the followings in terms of capacity, expenses, processing power, size and users they support: Supercomputers Mainframe Computers Comparison Element Supercomputers Mainframe Computers
QUESTION 1 (50 MARKS) For the past two years, Adam and his family have operated a...
QUESTION 1 For the past two years, Adam and his family have operated a part-time business from their home. The business, received a lot of attentions from the public, quickly building its reputation as an environmentally-conscious delivery service provider. The business has grown enormously and Adam decided to expand his family business, thinking about possibilities of running the business on a full-time basis. On 1st Dec 2019, Adam decided to rent a shop and to operate the business known as...
Question 4(24 Marks) Budgeting – To be done on Excel. Email your answer to tutor. Hudson...
Question 4 Budgeting – To be done on Excel. Email your answer to tutor. Hudson Holdings Ltd is a merchandising company that is preparing a master budget for the third quarter of the calendar year. The company’s balance sheet at June 30th is shown below: Hudson Holdings Ltd Balance Sheet June 30 ASSETS Cash $108,000 Accounts Receivable $163,200 Inventory $ 74,400 Plant & Equipment Net of Depreciation $252,000 Total Assets $597,600 LIABILITIES & STOCKHOLDERS’ EQUITY Accounts Payable $ 85,320 Shareholders’...
Use the data for two Sydney suburbs to answer questions 1-5:             1     Using Excel or other...
Use the data for two Sydney suburbs to answer questions 1-5:             1     Using Excel or other appropriate software, produce two separate histograms for the median rental prices of the two selected suburbs, respectively.            Use an appropriate number of bins for your histogram and remember to label the axes. Describe and compare the two histograms, including the central location, dispersion and skewness. [1 mark]                   2     Compute the sample means and sample standard deviations of the median rental prices...
In the Excel data file, the tab labeled Question 1 contains data on the number of...
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. Males 9,8,4,9,3,8,10,8,9,10,7,6,12 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?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT