Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The Department of Service Financing in the city of Belmont, NY has been experimenting with having city units provide services in house versus having private

The Department of Service Financing in the city of Belmont, NY has been experimenting with having city units provide services in house versus having private contractors provide the same services. In the city Grounds Department, half of the landscaping work is performed by city crews, whereas the other half is performed by a private landscaping firm. The city manager has collected random samples of weekly expense report data for both providers. He asks you to conduct a difference of mean test. What can the city manager conclude about the difference between in-house and private service provision.

I did a "t-Test: Paired Two Sample for Means: in Excel and came up with the following data (below). Is this the right step and if so what is the conclusion? Thanks

t-Test: Paired Two Sample for Means






Variable 1

Variable 2

Mean

3486.84

3409.384

Variance

1104457.765

968912.5

Observations

125

125

Pearson Correlation

-0.049611596


Hypothesized Mean Difference

0


df

124


t Stat

0.587055663


P(T<=t) one-tail

0.279116844


t Critical one-tail

1.65723497


P(T<=t) two-tail

0.558233687


t Critical two-tail

1.979280117



Step by Step Solution

There are 3 Steps involved in it

Step: 1

Use the tTest Paired Two Sample for Means tTest Pa... 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_2

Step: 3

blur-text-image_3

Document Format ( 2 attachments)

PDF file Icon
609a7a2148845_30662.pdf

180 KBs PDF File

Word file Icon
609a7a2148845_30662.docx

120 KBs Word File

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

Elementary Statistics

Authors: Robert R. Johnson, Patricia J. Kuby

11th Edition

978-053873350, 9781133169321, 538733500, 1133169325, 978-0538733502

More Books

Students also viewed these Mathematics questions

Question

=+a) Draw the decision tree.

Answered: 1 week ago