A retail company has started a new advertising campaign in order to increase sales. In the past, the mean spending in both the 18–35 and 35+ age groups was at most $70.00

a. Formulate a hypothesis test to determine if the mean spending has statistically increased to more than $70.00.

b. After the new advertising campaign was launched, a marketing study found that the sample mean spending for 400 respondents in the 18–35 age group was $73.65, with a sample standard deviation of $56.60. Is there sufficient evidence to conclude that the advertising strategy significantly increased sales in this age group with significance level of 5%?

c. For 600 respondents in the 35+ age group, the sample mean and sample standard deviation were $73.42 and $45.44, respectively. Is there sufficient evidence to conclude that the advertising strategy significantly increased sales in this age group with significance level of 5%?

please show work on excel!!!

3. Test the null hypothesis that the mean rating of Trump by profs is greater than or equal to the mean rating of Trump by students.   Use .10 significance level, a one tail test and the following data:

sample   profs       students

Mean      21           25

Variance 48           45

number 16           9

2 Test the hypothesis that the proportion of men who believe Hillary colluded with the Russians equals the proportion of women who believe Hillary colluded with the Russians.    Use a .01 significance level, a two tail test and the following data:

                                men                        women

students                 110                         100

Hillary colluded    45                           60

A factory manufactures alloy rods for construction companies. The lengths of rods are uniformly distributed with minimum of 80 and maximum of 120 cm. Find the 80th percentile of the length of the rods. Find the probability a rod is less than 101.4 cm long. Find the probability a rod is more than 102.5 cm long. Given that the rod is more than 101 cm, find the probability it is longer than 99 cm. Given that the rod is more than 101 cm, find the probability it is less than 103 cm.

The table below gives the age and bone density for five randomly selected women. Using this data, consider the equation of the regression line, yˆ=b0+b1x, for predicting a woman's bone density based on her age. Keep in mind, the correlation coefficient may or may not be statistically significant for the data given. Remember, in practice, it would not be appropriate to use the regression line to make a prediction if the correlation coefficient is not statistically significant. Age 37 39 40 50 64 Bone Density 357 347 344 343 336 Table Step 2 of 6 : Find the estimated y-intercept. Round your answer to three decimal places.

Consider the following data on price ($) and the overall score for six stereo headphones tested by a certain magazine. The overall score is based on sound quality and effectiveness of ambient noise reduction. Scores range from 0 (lowest) to 100 (highest).

Find the value of the test statistic. (Round your answer to three decimal places.)_____

Find the p-value. (Round your answer to four decimal places.)

p-value = ____

2.-Test for a significant relationship using the F test. Use α = 0.05.

Find the value of the test statistic. (Round your answer to two decimal places.)_____

Find the p-value. (Round your answer to three decimal places.)

p-value = ____

What is your conclusion?

Reject H₀. We conclude that the relationship between price ($) and overall score is significant.

Do not reject H₀. We conclude that the relationship between price ($) and overall score is significant.    

Reject H₀. We cannot conclude that the relationship between price ($) and overall score is significant.

Do not reject H₀. We cannot conclude that the relationship between price ($) and overall score is significant.

(c)Show the ANOVA table for these data. (Round your p-value to three decimal places and all other values to two decimal places.)

1.-The following data were used in a regression study.

(a)Develop an estimated regression equation for these data. (Round your numerical values to two decimal places.)

ŷ =______

2.-The following data show the brand, price ($), and the overall score for six stereo headphones that were tested by a certain magazine. The overall score is based on sound quality and effectiveness of ambient noise reduction. Scores range from 0 (lowest) to 100 (highest). The estimated regression equation for these data is

ŷ = 20.987 + 0.340x, where x = price ($) and y = overall score.

(a)Compute SST, SSR, and SSE. (Round your answers to three decimal places.)

SST=___

SSR=___

SSE=___

(b)Compute the coefficient of determination r².(Round your answer to three decimal places.)

r²=___

c)What is the value of the sample correlation coefficient? (Round your answer to three decimal places.)____

Please explain what type of test to perform a statistical significant difference of 0.05 and how to perform it on excel.

Treatment: Non-treated supernatant, n=2, but each sample is measured twice, so there are 4 concentrations: 16.425, 16.175, 18.325, 17.925

Treatment: Stressed supernatant, n=2, but each sample is measure twice, so there are 4 concentrations: 2.425, 2.925, 3.175, 2.355

An executive at the home office of Big Rock Life Insurance is considering three branch managers as candidates for promotion to vice president. The branch reports include records showing sales volume for each salesperson in the branch (in hundreds of thousands of dollars). A random sample of these records was selected for salespersons in each branch. All three branches are located in cities in which per capita income is the same. The executive wishes to compare these samples to see if there is a significant difference in performance of salespersons in the three different branches. If so, the information will be used to determine which of the managers to promote.

(b) Find

SS_TOT, SS_BET, and SS_W

and check that

SS_TOT = SS_BET + SS_W.

(Round your answers to three decimal places.)

Find

d.f._BET, d.f._W, MS_BET, and MS_W.

(Round your answers to three decimal places.)

Find the value of the sample F statistic. (Round your answers to three decimal places.)


What are the degrees of freedom?
(numerator)=
(denominator)=

(f) Make a summary table for your ANOVA test. (Round your answers to three decimal places.)

How does prediction work in the social and behavioral sciences? What can it be used to examine? What research questions might be addressed using prediction?

The Morton Supply Company produces clothing, footwear, and accessories for dancing and gymnastics. They produce three models of pointe shoes used by ballerinas to balance on the tips of their toes. The shoes are produced from four materials: cardstock, satin, plain fabric, and leather. The number of square inches of each type of material used in each model of shoe, the amount of material available, and the profit/model are shown below:

Please help answer the following:

Math & Music (Raw Data, Software Required):
There is a lot of interest in the relationship between studying music and studying math. We will look at some sample data that investigates this relationship. Below are the Math SAT scores from 8 students who studied music through high school and 11 students who did not. Test the claim that students who study music in high school have a higher average Math SAT score than those who do not. Test this claim at the 0.05 significance level.

You should be able copy and paste the data directly into your software program.

(a) The claim is that the difference in population means is positive (μ₁ − μ₂ > 0). What type of test is this?

This is a right-tailed test.This is a two-tailed test.    This is a left-tailed test.

(b) Use software to calculate the test statistic. Do not 'pool' the variance. This means you do not assume equal variances.
Round your answer to 2 decimal places.

t =

(c) Use software to get the P-value of the test statistic. Round to 4 decimal places.
P-value =

(d) What is the conclusion regarding the null hypothesis?

reject H₀fail to reject H₀    

(e) Choose the appropriate concluding statement.

The data supports the claim that students who study music in high school have a higher average Math SAT score than those who do not.There is not enough data to support the claim that students who study music in high school have a higher average Math SAT score than those who do not.    We reject the claim that students who study music in high school have a higher average Math SAT score than those who do not.We have proven that students who study music in high school have a higher average Math SAT score than those who do not.

Cars get parked in a lot (with infinite capacity) according to a λ-rate Poisson process, and indepen- dently stay parked for a random duration. The parking time duration of a car follows a common distribution X, with cdf F(x) = P(X ≤ x). Let N(t) be the number of cars parked at time t.

1a. What is the distribution of N(t)?

1b. Assuming a car arrival rate of 1 per minute, and X (in min) ∼ Gamma(3, 1) (as defined in class), what is the expected number of cars parked after 1 hour?

2. In the long run (t → ∞), what is the expected number of cars, as a function of λ and the moments of X?

Given the following sample observations, draw a scatter diagram on a separate piece of paper. (Round your answers to 3 decimal places.) X: -6 -17 12 3 17 Y: 52 248 151 4 341

The coefficient of correlation is .

Does the relationship between the variables appear to be linear?

Try squaring the X- variable and then determine the correlation coefficient. .