Question

Using the “Bus Maintenance.xls” file that is posted with the assignment, carry out a “t-test: Two-Sample Assuming Unequa...

Using the “Bus Maintenance.xls” file that is posted with the assignment, carry out a “t-test: Two-Sample Assuming Unequal Variances” in Excel (with α = 0.05) that tests whether there is a difference in mean maintenance costs between buses with Diesel engines and those with gasoline engines.

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Cannot find the attachment in this question. Please re-post by including the attachment. Thanks.

Add a comment
Know the answer?
Add Answer to:
Using the “Bus Maintenance.xls” file that is posted with the assignment, carry out a “t-test: Two-Sample Assuming Unequa...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Part (a)    Using the THE TABLE BELOW that is posted with the assignment, carry out...

    Part (a)    Using the THE TABLE BELOW that is posted with the assignment, carry out a “t-test: Two-Sample Assuming Unequal Variances” in Excel (with α = 0.05) that tests whether there is a difference in mean maintenance costs between buses with Diesel engines and those with gasoline engines. using Excel file include the output as part of the answer Part (b)    Based on the t-test, what is your decision (“reject” or “do not reject”) regarding the null hypothesis...

  • Part (a) Open the "Union Status and Income. xlsx" file that is posted with the assignment. In ord...

    part (a) Open the "Union Status and Income. xlsx" file that is posted with the assignment. In order to test whether there is a difference in the variance of income between Union members and non-Union members, use Excel to carry out an "F-Test: Two-Sample for variances" with Alpha =0.05 part (b) Still using the "Union Status and Income .xlsx" file, carry out a t-test in excel (with Alpha=0.05) that tests whether there is a difference in mean income between Union...

  • Using the t-Test Exercise Data Set Excel file, Look at the date set of Systolic Blood...

    Using the t-Test Exercise Data Set Excel file, Look at the date set of Systolic Blood Pressure Normal Weight/Systolic Blood Pressure Obese Write a null hypothesis for the comparison (use the null hypothesis template). Also, write a directional hypothesis that reflects the anticipated outcome. Conduct a t-test two-sample assuming unequal variances using Excel. Interpret the Excel result (was it significant, what was the critical t-value, what was the calculated t-value, what should be done with the null hypothesis—accept or reject)....

  • Stress between males and females *Note: alpha = .001 1 t-Test: Two-Sample Assuming Unequal Variances Female...

    Stress between males and females *Note: alpha = .001 1 t-Test: Two-Sample Assuming Unequal Variances Female Male 4 Mean 5 Variance 6 Observations 7 Hypothesized Mean Difference 3.655737705 3.52857143 1.296174863 1.12236025 70 61 8 df 9 t Stat 10 P(T-t) one-tail 11 t Critical one-tail 12 P(T<-t) two-tail 13 t Critical two-tail 124 0.658596658 0.255687918 3.157259054 0.511375836 3.370720124 Student Survey Data (2 Sample t-test) 1. Test Decision & Basis 2. Interpretation of Test Decision:

  • 3. You will need to download the data file "Wet Suits" from Sakai. Researchers are interested...

    3. You will need to download the data file "Wet Suits" from Sakai. Researchers are interested in finding out if wet suits allow a swimmer to swim faster. Researchers measured the speed (in meters per second) of swimmers both with and without a wet suit. The results of the study are shown in the table. A normal probability plot indicates the differences d = with - without are approximately normally distributed. Swimmer With 1.57 1.47 1.42 1.35 1.22 1.75 1.64...

  • Question 2 refers to the chart of numbers please show work and attach files if could sor...

    question 2 refers to the chart of numbers please show work and attach files if could sorry for the small pictures but attach files if needed thank you ! heres pictures zoomed in Question 3 points) Suppose that someone claims that the mean income of two group of individuals is equal. In order to test that claim, a researcher earns $1,448 more on average than the other group. Is that sufficient evidence to reject the claim that the mean income...

  • How do I write the results of this t-test out in a statsically way ? $120,000...

    How do I write the results of this t-test out in a statsically way ? $120,000 $75,000 t-Test: Two-Sample Assuming Unequal Variances Mean College Degree 131233.3333 1795633333 30 High School Degree (Only) 60966.66667 582171264.4 Variance Observations Hypothesized Mean Difference df 46 t Stat P(T<=t) one-tail t Critical one-tail PIT<=t) two-tail t Critical two-tail 7.892632799 2.1299E-10 1.678660414 4.2598E-10 2.012895599

  • t-Test: Two-Sample Assuming Equal Variances Variable 1 Variable 2 Mean 12.89795918 17.66666667 Variance 161.2185374 567.8266667 Observations...

    t-Test: Two-Sample Assuming Equal Variances Variable 1 Variable 2 Mean 12.89795918 17.66666667 Variance 161.2185374 567.8266667 Observations 49 51 Pooled Variance 368.6716646 Hypothesized Mean Difference 0 Df 98 t Stat -1.241549191 P(T<=t) one-tail 0.108683158 t Critical one-tail 1.660551217 P(T<=t) two-tail 0.217366316 t Critical two-tail 1.984467455 Is there a significant difference between the two sample means?  If you answer, “yes,” what is your reasoning?  If you answer, “no,” what is your reasoning? Please state the conclusion, or your interpretation of the results in terms...

  • Suppose you want to determine whether there is a significant difference in mean test scores for...

    Suppose you want to determine whether there is a significant difference in mean test scores for females and males. The test is out of 600 points. Using the following hypotheses: Ho: U1 - U2 = 0 HA: U1 - U2 (not equal) 0 And alpha of 0.05 you obtain the following results t-test Two-sample assuming unequal variances Females   Males Mean 525 487 Variance 3530.8 2677.818182 Observations 16 12 Hypothesized Mean Difference 0 df 25 t stat 1.803753 P (T<=t) one...

  • The objective of this is to carry out a hypothesis test using the Welch Approximate t...

    The objective of this is to carry out a hypothesis test using the Welch Approximate t Procedure, to determine if there is evidence of a difference in the caffeine content between sugar and diet soda. ** I know longer type question so posted it 3-4 times to help :) ** A) Use the Data Analysis ToolPak to carry out the Welch Approximate t Procedure. Include the output from Excel as a figure : B) Identify the value of the test...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT