Help - I need a spreadsheet with statistics!
bigbubbacarneyUniversity is concerned that out of state employees may be receiving lower wages than local workers.Twoindependentrandom samples have been selected: 165 observations frompopulation 1 (Out of stateworkers) and177 frompopulation 2 (local). The samplemeans obtainedareX1(bar)=86 and X2(bar)=87.It is known fromprevious studies that the population variances are8.1 and 7.3 respectively. Using a level of significanceof.01, is there evidence that theout of state workers may be receiving lower wages?Fullyexplain your answer.
I need this as a spreadsheet!
13 years ago
5
Answer(1)![blurred-text]()
Purchase the answer to view it
NOT RATED
hypothesis_test_in_excel.xls
Bids(0)
other Questions(10)
- about what percentage of U.S. citizens have government jobs?
- Phil Davis purchased a $75,000, 5 year term life insurance policy when he was 40. now he is 45
- A researche wishes to estimate the mean resting heart rate for long-distance runners. A random sample of 12 long-distance runners...
- Find the volume of a rectangular solid that is 8 inches long, 6 inches wide, and 4 inches high.
- Economics problems
- for the standard normal curve, find the z-score that corresponds to the 90th percentile
- DA mike bayville
- Allen today is the next assignment. R U ready?
- Function E is represented by the following description The value of y is equal to the sum of x and...
- 8 page paper on " How does the terrorist group FARC affects Ecuador" It has to have 5 sources.
