Question: Using Excel, show the correct functions to solve T test equation. Week # Weekly Weekly Sales($) Sales($) - Rep A - Rep B 4700 5900

Using Excel, show the correct functions to solve T test equation.

Week # Weekly Weekly Sales($) Sales($) - Rep A - Rep B 4700 5900 6100 2600 3438 2845 7394 4763 You want to determine whether there is a statistically different 4350 3740 Hypothesis test format average weekly 2552 2315 sales between Sales Rep A and Sales Rep B. 7063 1599 7844 1629 Step | State Hypothesis 6898 2416 Ho Create Null and Alternative Hypothesis statements that would allow 4003 2107 Ha you 6884 4237 12 4007 6322 to determine whether or not their sales performance is statistically Step II Choose significance level (alpha) 13 7214 3725 a= different. 14 2358 5890 15 7745 5119 16 Step III Calculate test statistic and p value 1337 5184 Use a significance level of .05 to conduct a t-test of independent 1052 3439 samples 17 Step IV Decision Rule 18 6052 4828 Reject Ho if p value

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

I need help with my part 1 and part 2.can you finished ,thank u FINA 415-15S PART 2 (VBA) # Worksheet Name 1 A 2 B Description Programing user defined function (30 marks) Subroutine to generate after...

I need help with part,can you help me finish it?thank u FINA 415-15S Exam PART 1 Excel # 1 2 3 4 5 6 Worksheet Name Solver Look Up Function Matrix Pivot table Data Table Offset Function Description...

Using Excel, show the correct function to solve the equation. A random sample of size 60 is taken from a population with mean 55 and standard deviation 2. Find P (x bar

Using Excel, show the correct function (i.e. =CONFIDENCE(..." (etcetera) to solve the equation. A research study investigated differences between male and female students. Based on the study results,...

Using Excel, show the correct formula to solve the equation. A sample of 100 items has a population standard deviation of 5.2 and a mean of 24. Construct a 95 percent confidence interval for .

Using Excel, show the correct function (i.e. =CONFIDENCE(..." (etcetera) to solve the equation. A manufacturing company measures the weight of boxes before shipping them to the customers. If the box...

Using Excel, show the correct function (i.e. =CONFIDENCE(..." (etcetera) to solve the equation. A random sample of size 60 is taken from a population with mean 55 and standard deviation 2. Find P (x...

Using Excel, show the correct function (i.e. "=CONFIDENCE(..." to solve the equation. At the end of 1990, 1991, and 1992, the average prices of a share of stock in a portfolio were $34.75, $34.65,...

Question: Please help me answer the following. Choose the correct answer and include explanations. 1. Mr. A purchased a 9-day treasury bill. It was issued 2 days before the national election. Suppose...

can someone help me solve this? the data and informatiin is there for JP Morgan Chase with all the instructions. I sent the images in parts. it should be more clear now. unless you want me to email...

Would you consider the completion of the first hardware phase a milestone or a phase-gate review?

Document for Analysis: Poorly Written Response The following letter suffers from a number of weaknesses discussed in this chapter. Your Task. Study the letter and analyze its faults. In teams or in a...

Select all that apply A written audit report regarding whether the financial statements are presented fairly is based on the applicable financial reporting framework is based on the evidence obtained...

PLEASE ANSWER THIS ASAP!! 3 Extra Credit (Ch1-8, 35 points) Spring, 2019 cm 3. E3-41B Record journal entries (5 points) Following transactions were incurred by Giregor Fabricators during January, the...