+1 123 456 7890 instantessays65@gmail.com

(answered) – 1- Suppose a study reports that the average price for a gallon of

$11.00

(answered) – 1- Suppose a study reports that the average price for a gallon ofDescriptionSolution downloadThe Question1- Suppose a study reports that the average price for a gallon of self-serve regular unleaded gasoline is$3.16. You believe that the figure is higher in your area of the country. You decide to test this claimfor your part of the United States by randomly calling gasoline stations. Your random survey of 25stations produces the following prices (all in dollars). Assume gasoline prices for a region arenormally distributed.Did the data you obtained provide enough evidence to reject the claim? Use a 1% level of significance.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.3-?To answer this question, use the Data Analysis Toolpack in Excel and select ?t-Test: Two-SampleAssuming 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 andcards on Valentine?s Day. Suppose a researcher wants to test this hypothesis by randomly sampling?9 men and 10 women with comparable demographic characteristics from various large cities acrossthe United States to be in a study. Each study participant is asked to keep a log beginning 1 monthbefore Valentine?s Day and record all purchases made for Valentine?s Day during that 1-monthperiod. The resulting data are shown below. Use these data and a 1% level of significance to test todetermine if, on average, men actually do spend significantly more than women on Valentine?s Day.Assume that such spending is normally distributed in the population and that the population variancesare 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).Unit 3[GB513: Business Analytics]Unit 3: AssignmentThis 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 Doc Sharing to submit your answers.Question 1Suppose 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 claimfor your part of the United States by randomly calling gasoline stations. Your random survey of 25stations produces the following prices (all in dollars). Assume gasoline prices for a region arenormally distributed.Did the data you obtained provide enough evidence to reject the claim? Use a 1% level ofsigni?cance.Make sure you clearly state both the null and the alternative hypotheses in full sentences. Followingyour calculations, clearly state the conclusion in the same manner (do not simply say ?accept/rejectnull?) and explain how you arrived at this conclusion (based on which metrics).3.273.33.163.153.113.053.083.123.133.143.163.19Unit 3[GB513: Business Analytics]3.273.143.143.23.33.093.053.073.373.343.353.353.1Question 2Where do CFOs get their money news? According to Robert Half International, 47% get their moneynews 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 researcherw

Reviews

There are no reviews yet.

Be the first to review “(answered) – 1- Suppose a study reports that the average price for a gallon of”

Your email address will not be published. Required fields are marked *