Questions: Question
An economist is studying salaries for high technology companies and wants to test the claim that the average salary for high tech employees is less than 70,000.
The economist selects a sample of 35 random employees from various high tech companies and records their salaries. Based on past studies, the economist determines that the population standard deviation is 8,500.
The economist conducts a one-mean hypothesis test at the 5% significance level to test the claim that the average salary for high tech employees is less than 70,000.
The setup for the null and alternative hypothesis is given as:
H0: μ ≥ 70,000; Ha: μ<70,000, which is a left-tailed test.
The sample data for 35 salaries is shown in the dataset below.
Use Excel to test the claim that the average salary for high tech employees is less than 70,000, where α=0.05. Calculate the test statistic, z, and the p-value, rounding to three decimal places.
Transcript text: Question
An economist is studying salaries for high technology companies and wants to test the claim that the average salary for high tech employees is less than $\$ 70,000$.
The economist selects a sample of 35 random employees from various high tech companies and records their salaries. Based on past studies, the economist determines that the population standard deviation is $\$ 8,500$.
The economist conducts a one-mean hypothesis test at the $5 \%$ significance level to test the claim that the average salary for high tech employees is less than $\$ 70,000$.
The setup for the null and alternative hypothesis is given as:
$H_{0}: \mu \geq 70,000 ; H_{a}: \mu<70,000$, which is a left-tailed test.
The sample data for 35 salaries is shown in the dataset below.
Use Excel to test the claim that the average salary for high tech employees is less than $\$ 70,000$, wh $\alpha=0.05$. Calculate the test statistic, $z$, and the $p$-value, rounding to three decimal places.
Solution
Solution Steps
Step 1: Calculate the Sample Mean
The sample mean \( \bar{x} \) is calculated as follows: