Quarter Enrollments in Business Statistics course at a major university are given in the EXCEL worksheetEnrollment:

1. Develop an additive model for trend and seasonality. Please clearly define your variables.

b. Use the additive model to forecast for the enrollments for Fall 2013, Winter 2014, and Spring 2014.

Please show step by step instructions using excel:

Priority Dispatching Rules

1. Consider the following data:

1. Calculate for each job the relative critical ratio.
2. Analyze the calculated critical ratio.
3. Basing on the calculated CR, specify the scheduling order of each job. Justify your answer.
4. Specify and explain a second dispatch rule that can be adopted.   
5. Among the two rules which seems to be the most effective. Justify your answer.

1. Ten samples of 15 parts each were taken from an ongoing process to establish a p chart for control. The samples and the number of defectives in each are shown in the following table:

1. Develop a p-chart for 99.7 percent confidence (3 standard deviations).
2. Based on the plotted data points, what comments can you make?

7. The Supplemental Assistance Nutritional Program is the name for the federal government Food stamp program. At the end of the year 2014 the national statistics were staggering of 114 million households, 23 million were receiving food stamps. Social scientists wish to know if the percentage of California households receiving food stamps is the same as that of Florida. Random samples of 1,000 households are obtained for California and Florida and the number of households receiving food stamps is 180 and 150, respectively.

a. Find the percentage of households in the sample receiving food stamps for California and Florida.

b. Test the hypothesis that the "percentage of households receiving food stamps is the same in California as it is in Florida". Write the appropriate null and alternative hypotheses and use a significance level of 0.05. Make sure to give a decision and write a conclusion.

c. Compute the 95% Confidence Interval for the difference in the percentage of households receiving food stamps in California and Florida.

d. Does the Confidence Interval computed in part c agree with your decision in part b? Answer Yes or No and explain.

A report regarding the status of corona virus spread in California published Monday (March 23, 2020) showed 2133 positive cases out of a total 25,200 tests. Using the 95% confidence level, what is the confidence interval for the proportion of California residents having the corona virus.

BONUS: A population has a standard deviation of 50. A randomly selected sample of 51 items is taken from the population. The sample has a mean of 52. What is the margin of error at the 90% confidence interval? 95% confidence interval? 99% confidence interval?

1. A researcher is interested in comparing a new self-paced method of teaching statistics with the traditional method of conventional classroom instruction. On a standardized test of knowledge of statistics, the mean score for the population of students receiving conventional classroom instruction is μ = 60. At the beginning of the semester, she administers a standardized test of knowledge of statistics to a random sample of 30 students in the self-paced group and finds the group mean is

M = 55 and s = 14. Assume you wish to determine whether the performance for the self-paced group differs significantly from the performance of those students enrolled in courses offering conventional classroom instruction.

a. State the null hypothesis.

b. Make a diagram of the regions of acceptance and rejection associated with the null hypothesis and label the horizontal axis in terms of values of the t-statistic. Use alpha = .05, two tailed test.

c. Calculate the value of the t-statistic associated with the sample mean of M = 55.

d. Make your decision to reject and retain and describe what this means.

A popular film series has produced 24 films of which 16 have been good. A new film from the series is about to come out, and without any additional information we would assume that the odds it is good is 16 out of 24. Historically, 65.7% of good films have a good trailer and 21.8% of bad films have a good trailer. The new film releases a good trailer. What is the probability that the film is good now?

put your answer in percentage form (e.g. 72.4218 not 0.724218) and then round to four decimal places. You do NOT need to include a % sign.

Suppose that you like about 75.5% of the movies that you see. Rotten Tomatoes is a website which certifies movies as either “fresh” or “rotten”. About 79.2% of movie you like are certified “fresh” on rotten tomatoes, and about 16.5% of movies you do not like are certified “fresh”. A new movie you are thinking about seeing is certified “fresh”. What is the probability that you will like it?

where the answer is a probability, put your answer in percentage form (e.g. 72.4218 not 0.724218) and then round to four decimal places. You do NOT need to include a % sign.

A clinical trial was conducted to test the effectiveness of a drug used for treating insomnia in older subjects. After treatment with the​ drug, 11 subjects had a mean wake time of 92.9 min and a standard deviation of 44.9 min. Assume that the 11 sample values appear to be from a normally distributed population and construct a 90​% confidence interval estimate of the standard deviation of the wake times for a population with the drug treatments. Does the result indicate whether the treatment is​ effective ?

​​​​​​

1. 1. For women aged 18-24, systolic blood pressures are normally distributed with a mean of 114.8 mm Hg and a standard deviation of 13.1 mm Hg (based on data from the National Health Survey). Hypertension is commonly defined as a systolic blood pressure above 140 mm Hg.

1. If a woman between the ages of 18 and 24 is randomly selected, find the probability that her systolic blood pressure is greater than 140.
2. If 4 women in that age bracket are randomly selected, find the probability that their mean systolic blood pressure is greater than 140.
3. Given that part b) involves a sample size that is not larger than 30, why can the central limit theorem be used?
4. If a physician is given a report stating that 4 women have a mean systolic blood pressure below 140, can she conclude that none of these women has hypertension?

2. The population mean for commute time is 25.1 minutes and the standard deviation is 10.2 minutes in Aurora, CO.

a) Based on a sample size of 35 individuals, determine the two-sided 90% confidence interval for the distribution of commute times for this population.

b) The sample that we selected above has a mean commute time of 35 minutes. Based on our confidence interval, does the sample of individuals appear to be representative of the population? Why or why not?

2. We want to determine whether UCCS students who are successful in getting into grad school have higher GRE scores compared to all UCCS students who took the GRE exam. We select a random sample (n=20) of successful grad school applicants from UCCS. Based on our sample, the mean is 550 and the standard deviation is 60. The population mean for all UCCS students who took the exam was 480. GRE scores are normally distributed.    

a) What would be the 2-sided 99% confidence interval?

b) Based on the 99% confidence interval, do successful grad school applicants appear to have a higher average score on the GRE exam compared to all UCCS students who took the exam? Why or why not?

3. In an effort to determine whether exposure to high lead levels has an effect on blood pressure in young children, blood-pressure measurements were taken on 30 children aged 5-6 years living in a specific community exposed to high lead levels. For these children, the mean diastolic blood pressure was found to be 66.2 mm Hg with standard deviation 7.9 mm Hg. From a nationwide study, we know that the mean diastolic blood pressure is 58.2 mm Hg for 5- to 6-year old children. We will assume that exposure to lead will have either no effect or cause an increase in blood pressure. Determine a one-sided 95% confidence interval for diastolic blood pressure among 5- to 6-year-old children in this community based on the observed 30 children. Based on this confidence interval, does it appear that children who are exposed to lead have higher blood pressure?

Description: The data are from a national sample of 6000 households with a male head earning less than $15,000 annually in 1966. The data were classified into 39 demographic groups for analysis. The study was undertaken in the context of proposals for a guaranteed annual wage (negative income tax). At issue was the response of labor supply (average hours) to increasing hourly wages. The study was undertaken to estimate this response from available data

SOLVE: Use SAS software to answer the following questions by using simple linear regression.

Research questions:

Do labor hours increase or decrease with wage rates?

What other factors affect the number of hours that people work?

The comparison between the correlation of wages and ages, and wages and schooling.

DATA BELOW:

HRS    RATE ERSP ERNO NEIN ASSET AGE DEP RACE SCHOOL

2157   2.905   1121   291   380   7250   38.5   2.340   32.1   10.5

2174   2.970   1128   301   398   7744   39.3   2.335   31.2   10.5

2062   2.350   1214   326   185   3068   40.1   2.851   *   8.9

2111   2.511   1203   49   117   1632   22.4   1.159   27.5   11.5

2134   2.791   1013   594   730   12710   57.7   1.229   32.5   8.8

2185   3.040   1135   287   382   7706   38.6   2.602   31.4   10.7

2210   3.222   1100   295   474   9338   39.0   2.187   10.1   11.2

2105   2.493   1180   310   255   4730   39.9   2.616   71.1   9.3

2267   2.838   1298   252   431   8317   38.9   2.024   9.7   11.1

2205   2.356   885   264   373   6789   38.8   2.662   25.2   9.5

2121   2.922   1251   328   312   5907   39.8   2.287   51.1   10.3

2109   2.499   1207   347   271   5069   39.7   3.193   *   8.9

2108   2.796   1036   300   259   4614   38.2   2.040   *   9.2

2047   2.453   1213   297   139   1987   40.3   2.545   *   9.1

2174   3.582   1141   414   498   10239   40.0   2.064   *   11.7

2067   2.909   1805   290   239   4439   39.1   2.301   *   10.5

2159   2.511   1075   289   308   5621   39.3   2.486   43.6   9.5

2257   2.516   1093   176   392   7293   37.9   2.042   *   10.1

1985   1.423   553   381   146   1866   40.6   3.833   *   6.6

2184   3.636   1091   291   560   11240   39.1   2.328   13.6   11.6

2084   2.983   1327   331   296   5653   39.8   2.208   58.4   10.2

2051   2.573   1194   279   172   2806   40.0   2.362   77.9   9.1

2127   3.262   1226   314   408   8042   39.5   2.259   39.2   10.8

2102   3.234   1188   414   352   7557   39.8   2.019   29.8   10.7

2098   2.280   973   364   272   4400   40.6   2.661   53.6   8.4

2042   2.304   1085   328   140   1739   41.8   2.444   83.1   8.2

2181   2.912   1072   304   383   7340   39.0   2.337   30.2   10.2

2186   3.015   1122   30   352   7292   37.2   2.046   29.5   10.9

2108   2.786   1757   *   506   9658   43.4   *   32.6   10.2

2188   3.010   990   366   374   7325   38.4   2.847   30.9   10.6

2203   3.273   *   *   430   8221   38.2   2.324   22.1   11.0

2077   1.901   350   209   95   1370   37.4   4.158   61.3   8.2

2196   3.009   947   294   342   6888   37.5   3.047   31.8   10.6

2093   1.899   342   311   120   1425   37.5   4.512   62.8   8.1

2173   2.959   1116   296   387   7625   39.2   2.342   31.0   10.5

2179   2.971   1128   312   397   7779   39.4   2.341   31.2   10.5

2200   2.980   1126   204   393   7885   39.2   2.341   31.0   10.6

2052   2.630   *   *   154   3331   40.5   *   45.8   10.3

2197   3.413   1078   300   512   10450   39.1   2.297   15.5   11.3

1)In a distribution of IQ scores, where the mean is 100 and the standard deviation is 15........

-Compute the z score for an IQ of 100

-Compute the z score for an IQ of 107

2)For all US women, assuming a normal distribution - Mean height is 64 inches ; Standard deviation is 2.4 inches

-What percentage of US women are 60 inches or shorter?

-What percentage of US women have a height between 64 and 67 inches?

A physicist claims that more than 19% of all persons exposed to a certain amount of radiation will feel discomfort. A researcher selected a random sample, 48 of 220 persons exposed to radiation felt discomfort.

Identify the significance level. Check the assumptions to identify the sampling distribution under null hypothesis. Compute the P-value.

M/PF Research, Inc. lists the average monthly apartment rent in some of the most expensive apartment rental locations in the United States. According to their report, the average cost of renting an apartment in Minneapolis is $951. Suppose that the standard deviation of the cost of renting an apartment in Minneapolis is $96 and that apartment rents in Minneapolis are normally distributed. If a Minneapolis apartment is randomly selected, what is the probability that the price is: (Round the values of z to 2 decimal places. Round answers to 4 decimal places.) (a) $1,000 or moreb0 between 900 and $1,110? c) Between $830 and $930? Entry field with incorrect answer (d) Less than $730?