Hypothesis Testing and Excel Functions

Dr. Pyus guides students through module five's assignment, focusing on hypothesis testing in Excel. The project involves a salesperson's claim about home sales costs in the Pacific region. Students learn to prepare data, conduct a hypothesis test, and interpret results. Detailed instructions for completing the assignment are provided.

What is the main focus of the module 5 assignment?

• Setting up a hypothesis test in Excel

• Designing a new product

• Analyzing sales data

• Creating a marketing plan

What claim does the salesperson want to make in the advertisement?

• The average cost per square foot is equal to the Pacific region's average

• The average cost per square foot is unknown

• The average cost per square foot is greater than the Pacific region's average

• The average cost per square foot is less than the Pacific region's average

What is the purpose of the hypothesis test in this assignment?

• To calculate the total sales

• To compare different regions

• To find the average cost per square foot

• To confirm the salesperson's claim

Which Excel function is used to generate random numbers?

• AVERAGE()

• STDEV()

• RAND()

• SUM()

What is the significance of the central limit theorem in this context?

• It allows the use of a T-Test despite non-normal distribution

• It helps in calculating the average

• It is used to sort data

• It determines the sample size

What does a very small P value indicate in hypothesis testing?

• The sample size is too small

• Strong evidence against the null hypothesis

• No evidence against the null hypothesis

• The data is normally distributed

How can you insert the Greek letter 'mu' in a Word document?

• By typing 'mu'

• Using Alt + 230

• Copying from a website

• Both B and C