The Westchester Chamber of Commerce periodically sponsors public service seminars and programs. Currently, promotional plans are under way for this year’s program. Advertising alternatives include television, radio, and newspaper. Audience estimates, costs, and maximum media usage limitations are as shown

Constraint

Television Radio Newspaper

Audience per advertisement

100,000 18,000 40,000

Cost per advertisement

$2000 $300 $600

Maximum media usage

10 20 10

I NEED EXCEL FILE WHICH HAS EXCEL SPREADSHEET AND SENSITIVITY REPORT FOR THIS PROBLEM

Hypothesis: Anti-smoking television PSAs reduces cigarette smoking.

Study design: 500 Individuals were randomly assigned to watch a PSA about wearing seat belts (control group) and 532 individuals were randomly assigned to watch a PSA about the dangers of smoking (treatment group). A week after the study, the same individuals were asked to complete a survey. In the control group, 102 people reported smoking cigarettes in the previous week and in the treatment group, 85 people reported smoking cigarettes in the previous week. (15 points)

Determine the appropriate test: z-test or t-test. Explain why you chose that test.

Calculate the appropriate test statistic

Decide whether you should reject the null hypothesis.

Research shows that on campus break-ins at CSUN and UCLA during the past 24 months averaged 15 and 12 per month, respectively, with unbiased standard deviations of 4 and 3, respectively. Use the five steps of hypothesis testing to see if there a significant difference between these numbers on the two campuses (Use P<.01, alpha = 2.819)

After building a regression model and performing residual diagnostics, you notice that the errors show severe departures from normality and appear to have nonconstant variance. What steps would you take in this case to resolve the errors? If the problems are not corrected after all steps are taken, what does that imply about the modeling approach you are taking? Explain in detail.

Construct two confidence intervals for the population mean: a 95% confidence interval and a 99% confidence interval. Assume that your data is normally distributed and the population standard deviation is unknown Here is the data set of 60 numbers. 69 35 60 55 49 60 72 70 70 73 68 72 74 69 46 48 70 55 49 60 72 70 76 56 59 64 71 69 55 61 70 55 45 69 54 48 60 61 50 59 60 62 63 53 64 50 69 52 68 70 69 59 58 69 65 61 59 71 71 68

The Pearson correlation coefficient (r) equals one when there is strong linear relationship between x and y.

True/False

Independent-Samples t-Test

A researcher wants to assess if fasting cholesterol levels differ in Type A and Type B personality men (alpha= .05).

Group 1 (Type A personality): 233, 291, 312, 250, 246, 197, 268, 224, 239, 239, 254, 276, 234, 181, 248, 252, 202, 218, 212, 325

Group 2 (Type B personality): 344, 185, 263, 246, 224, 212, 188, 250, 148, 169, 226, 175, 242, 252, 153, 183, 137, 202, 194, 213

1. Enter these data into SPSS.
2. Compute an independent-samples t test on these data. Report the t values and p values assuming equal population variances and not assuming equal population variances.
3. Report descriptive statistics
4. Report results for the test evaluating homogeneity of variances (F=____; p = ____)

Problem #6

In a production process, four samples of three observations each have been taken, with actual measurements (in centimeters) shown below. Construct three-sigma mean and range charts.

1 2 3 4

12.3 11.9 12.0 12.1

12.2 12.2 12.2 11.8

12.1 12.2 11.8 11.8

A study of undergraduate computer science students examined changes in major after the first year. The study examined the fates of 256 students who enrolled as first-year students in the same fall semester. The students were classified according to gender and their declared major at the beginning of the second year. The students studied were enrolled at a large Midwestern university several years ago. Discuss how you would conduct a similar study at a college or university of your choice today. Include a description of all variables that you would collect for your study.

To test whether the enactment of seatbelt legislation had any association with injuries to vehicle users, a random sample of 7676 individuals taken over a two-year period (one year prior legislation and one year post legislation) was used. The results are detailed below.

Please write a summary statement for this hypothesis test.

A sample of 120 students in a high school reveals a mean height of 1.62 meters and a standard deviation of 7 centimeters.

Find 90% and 99% confidence intervals for the true mean height of the student population.

Starting at 9 a.m., students arrive to class according to a Poisson process with

parameter λ = 2 (units are minutes). Class begins at 9:15 a.m. There are 30

students.

(a) What is the expectation and variance of the number of students in class by

9:15 a.m.?

(b) Find the probability there will be at least 10 students in class by 9:05 a.m.

(c) Find the probability that the last student who arrives is late.

(d) Suppose exactly six students are late. Find the probability that exactly 15

students arrived by 9:10 a.m.

(e) What is the expected time of arrival of the seventh student who gets

to class?

Given that you have two cards of the same rank in a five card hand, what is the probability that you have,

a) a three of a kind

b) four of a kind

As Economic Analyst for High Desert Bank, analyze the amounts of commercial, consumers, and real estate loans.

1. Construct two 95% confidence intervals for each sample.

• Apply the population standard deviation (σ) in the formula to form z-distribution since the population standard deviation is known.
• Apply the sample standard deviation (s) in the formula to form t-distribution assuming the population standard deviation is unknown.