Conduct a hypothesis test using tool

Assignment Help Finance Basics
Reference no: EM131477831

Question 1

Suppose a study reports that the average price for a gallon of self-serve regular unleaded gasoline is $3.16. You believe that the ?gure is higher in your area of the country. You decide to test this claim for your part of the United States by randomly calling gasoline stations. Your random survey of 25 stations produces the following prices (all in dollars). Assume gasoline prices for a region are normally distributed.
Did the data you obtained provide enough evidence to reject the claim? Use a 1% level of signi?cance.

Make sure you clearly state both the null and the alternative hypotheses in full sentences. Following your calculations, clearly state the conclusion in the same manner (do not simply say "accept/reject null") and explain how you arrived at this conclusion (based on which metrics).

3.27

3.3

3.16

3.15

3.11

3.05

3.54

3.25

3.05

3.11

3.13

3.15

3.27

3.14

3.14

3.2

3.3

3.09

3.05

3.07

3.37

3.34

3.35

3.35

3.1

Question 2

Where do CFOs get their money news? According to Robert Half International, 47% get their money news from newspapers, 15% get it from communication/colleagues, 12% get it from television, 11% from the Internet, 9% from magazines, 5% from radio, and 1% do not know. Suppose a researcher wants to test these results. She randomly samples 76 CFOs and ?nds that 40 of them get their money news from newspapers. Does the test show enough evidence to reject the ?ndings of Robert Half International? Use a = .05.

Make sure you clearly state both the null and the alternative hypotheses in full sentences. Following your calculations, clearly state the conclusion in the same manner (do not simply say "accept/reject null") and explain how you arrived at this conclusion (based on which metrics).

Men

Women

107.48

125.98

143.61

59.32

90.19

96.35

125.53

80.62

70.79

77.6

83

84.34

129.63

75.21

154.22

68.48

93.8

65.84

111.25

126.11

78.6

82.54

89.35

123.5

Question 3

To answer this question, use the Data Analysis Toolpack in Excel and select "t-Test: Two-Sample Assuming Equal Variances" from the list of available tools. Conduct a hypothesis test using this tool. Explain your answer (how you decided if men spend more or not) and include the output table.

Some studies have shown that in the United States, men spend more than women buying gifts and cards on Valentine's Day. Suppose a researcher wants to test this hypothesis by randomly sampling men and women with comparable demographic characteristics from various large cities across the United States to be in a study. Each study participant is asked to keep a log beginning 1 month before Valentine's Day and record all purchases made for Valentine's Day during that 1-month period. The resulting data are shown below. Use these data and a 1% level of signi?cance to test to determine if, on average, men actually do spend signi?cantly more than women on Valentine's Day. Assume that such spending is normally distributed in the population and that the population variances are equal.

Make sure you clearly state both the null and the alternative hypotheses in full sentences. Include the output table; then, clearly state the conclusion in the same manner (do not simply say "accept/reject null") and explain how you arrived at this conclusion (based on which metrics).

Men

Women

107.48

125.98

143.61

59.32

90.19

96.35

125.53

80.62

70.79

77.6

83

84.34

129.63

75.21

154.22

68.48

93.8

65.84

111.25

126.11

78.6

82.54

89.35

123.5

Attachment:- Assignmenttemplate.rar

Verified Expert

This task provides a clear working example on one sample t test, one proportion z test and independent sample t test with equal variances assumed. here, the sample size is small and hence the t test was used to perform the analysis

Reference no: EM131477831

Questions Cloud

Create a matrix that lists each business : Create a matrix that lists each business, and compare and contrast your personal liability exposure as an owner as a result of the lawsuit.
What is the role of the media in driving psychological : How might rules for risk disclosure of derivative securities reflect psychological bias?
Explore what have you learned about statistics : The question to address is: "What have you learned about statistics?" In developing your responses, consider - at a minimum.
What is the role of scapegoating in the regulatory response : What is the role of scapegoating and overconfidence in the regulatory response to adverse economic events?
Conduct a hypothesis test using tool : Conduct a hypothesis test using this tool. Explain your answer (how you decided if men spend more or not) and include the output table.
Find the weight of the piece : A certain part of an aircraft engine has a volume of 1.5 ft3.
The company has collected information on the payoffs : A General Manger of Harley-Davidson has to decide on the size of a new facility. The GM has narrowed the choices to two: large facility or small facility.
What is the source level : (a) What is the source level (SL) is dB? (b) What is the absorption at 180 kHz? (c) What is the directivity index?
Estimate the cost of existing equity : Why is estimating the cost of common equity more difficult than estimating the cost of debt or preferred stock?

Reviews

len1477831

4/28/2017 8:07:04 AM

This Assignment requires you to use Excel only in Question 3. Follow all instructions carefully. Questions 1, 2, and 3 have specific requirements. Make sure to use the Unit 3 Assignment template located in Course Resources to submit your answers. Question 1 Correct null and alternative hypotheses in full sentences. 7 Question 1 Correct work, explanation, and conclusion in full sentences. 8 Question 2 Correct null and alternative hypotheses in full sentences. 7 Question 2 Correct work, explanation, and conclusion in full sentences. 8 Question 3 Correct null and alternative hypotheses in full sentences. 7 Question 3 Correct Excel table, explanation, and conclusion in full sentences. 8 Properly completed Assignment template. 5

Write a Review

Finance Basics Questions & Answers

  Financial reporting and analysis

Finance is about Gunns Ltd, a company in dealing with forestry products in Australia. The company has also been listed in Australian Stock Exchange. As many companies producing forestry products, even Gunns Ltd is facing various problems. Due to the ..

  A report on financial accounting

This report is specific for a core understanding for Financial Accounting and its relevant factors.

  Describe the types of financial ratios

Describe the types of financial ratios and other financial performance measures that are used during venture's successful life cycle.

  Differences between sole proprietorship and corporation

Briefly describe the major differences between a sole proprietorship and a corporation

  Prepare a cash budget statement

Calculate the expected value of the apartment in 20 years' time. What is the mortgage loan repayment at the beginning of each month

  What are the implied interest rates

What are the implied interest rates in Europe and the U.S.?

  State pricing theory and no-arbitrage pricing theory

State pricing theory and no-arbitrage pricing theory

  Small business administration

Identify the likely stage for each venture and describe the type of financing each venture is likely to be seeking and identify potential sources for that financing.

  Effect of financial leverage

The Effect of Financial Leverage and working capital management

  Evaluate the basis for the payment to the lender

Evaluate the basis for the payment to the lender and basis for the payment to the company-counterparty.

  Importance of opps, ipps, mpfs and dmepos

Research and discuss the differences and importance of : OPPS, IPPS, MPFS and DMEPOS.

  Time value of money

Time Value of Money project

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd