Question
Please the steps in manually and shows the formulas in excel A financial analyst for a recycling company has recently computed that the firm would
Please the steps in manually and shows the formulas in excel
A financial analyst for a recycling company has recently computed that the firm would make a profit by recycling newspapers if the mean household collection exceeded 2.0 pounds.
A random sample of 148 households was drawn from a large community, and the weekly weight of newspapers discarded for recycling for each household was recorded.
Do these data provide sufficient evidence to allow the analyst to conclude that a recycling plant would be profitable? Assume a significance level of 5%.
Put random data of 148 values by giving examples
Following details should get output as an example
1. t- value
2. P-values
3. 95 % confidence interval
4. Sample Estimates
Pounds |
1.5 |
1.8 |
3.2 |
2.3 |
1.8 |
3.2 |
3 |
1.7 |
2.2 |
3.3 |
1.3 |
1.4 |
2.1 |
2.2 |
2.3 |
2.8 |
1.6 |
2.7 |
0 |
2.5 |
2.2 |
2.1 |
0 |
4.2 |
2.3 |
1 |
1.3 |
3.1 |
1.1 |
2.7 |
2 |
0 |
1.3 |
4.3 |
1.9 |
0.8 |
3.3 |
1.4 |
1.5 |
2.2 |
2.1 |
2.4 |
1.9 |
2.7 |
1.4 |
0.6 |
3 |
1.3 |
2.2 |
3 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started