Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Reporting and Analysis

Authors: Flawrence Revsine, Daniel Collins, Bruce, Mittelstaedt, Leon

6th edition

9780077632182, 78025672, 77632184, 978-0078025679

More Books

Students also viewed these Mathematics questions

Question

What is management growth? What are its factors

Answered: 1 week ago