Please help set up this problem and create the pivot table in excel. 1. The attached file MBA.XLS contains the results of a study on the academic preparation of MBA students and their performance in a Quantitative Analysis Course. A group of 181 students, constituting a random sample, was classified according to their latest
Exercise # 14 The null and alternate hypotheses are: A random sample of 15 observations from the first population revealed a sample mean of 350 and a sample standard deviation of 12. A random sample of 17 observations from the second population revealed a sample mean of 342 and a sample standard deviation of 15. At the .10
1) Ms. Maria Wilson is considering running for mayor of the town of Bear Ghulch, Montana. Before completing the petitions, she decides to conduct a survey of voters in Bear Gulch. A sample of 400 voters reveas that 300 would support her in the November election. a) estimate the value of the population proportion. b) comput
#10 The chief of security for the Mall of the Dakotas was directed to study the problem of missing goods. He selected a sample of 100 boxes that had been tampered with and ascertained that for 60 of the boxes, the missing pants, shoes, and so on were attributed to shoplifting. For 30 other boxes employees had stolen the goods
Because of uncertainty in real estate markets, many homeowners are considering remodeling and constructing additions rather than selling. The most expensive room in the house to remodel is the kitchen, with an average cost of $23,400. In terms of resale value, is remodeling the kitchen worth the cost? The following cost and r
The national average for the price of a gallon of unleaded regular gas is $1.16. I believe the price is higher in my area of the country. I want to test my claim by randomly selecting gas prices for 25 stations in my area. The following prices are: $1.27 $1.29 $1.16 $1.20 $1.37 1.20 1.23 1.19 1.20 1.24
Need help working my way through the rest of the 5 steps with the information given. The null hypothesis is the average miles per gallon of fuel used in the Toyota Highlander hybrid vehicle, ?h is higher to equal to than that of a Toyota Hylander standard eight cyclinder, ?8. The alternative hypothesis is the average miles per
1.)If the population standard deviation ( s) is known then we use it in calculating the z-statistic as follows. z= [Xbar - m ] / [ s/ sqrt(n) ] On the other hand if population standard deviation is unknown, we substitute the sample standard deviation (s) in place of population standard deviation in calculating the z-statist
Can you explain P- value in easy to understand terms. Statistics is very confusing for me and I feel lost, any help you can give me will be greatly appreciated.
(See attached file for full problem description with proper symbols) Samples of sizes 10 and 18 taken from two normal distributions gave and Using the F distribution, show that F = 0.49 and 1/F = 2.04, and test the hypothesis
Given that X is a normal variable and given the sample values x̄ = 42, s = 6, n = 20, (a) test the hypothesis that μ = 44 by showing that student t = -1.49 and (b) show that 95% confidence limits for μ are 39.2 < μ < 44.8.
The manager of a computer software company wishes to study the number of hours senior executives spend at their desktop computers by type of industry. The manager selected a sample of five executives from each of three industries. At the .05 significance level, can she conclude there is a difference in the mean number of hours s
Under what conditions would a manager wish to utilize hypothesis testing?
1. The following are the GMAT scores and the GPA's of a random sample of 6 students in a graduate school. During a "cram" weekend the students learned several GMAT applications. With a 0.05 level of significance did the GPAs increase? BEFORE AFTER
A national survey of restaurant employees found that 75% said work stress had a negative impact on their personal lives. A sample of 100 employees from a popular restaurant chain finds that 68 answer "Yes" when asked, "Does work stress have a negative impact on you personal life?" Is there a eason to believe the restaurant chain
(See attached file for full problem description) --- 1. The manager of the BiLo Supermarket in Mt. Pleasant, Rhode Island, sampled the following information on the number of times a customer visits the store during a month. The responses of 51 customers were. If EXCEL is used, please import the information into this test d
HI, I am having difficulty understanding statistics. I had just completed a paper in which I made a statistical comparison using gas prices in 1975 and 2006. The gas prices were in today's dollars. I need to do a small sample size statistic with the same info and I'm lost. Could you walk me through this with the 5 step hypoth
Drugstore.com was the first e-commerce company to offer Internet drugstore retailing. Drugstore.com customers were provided the opportunity to buy health, beauty, personal care, wellness, and pharmaceutical replenishment products over the Internet. At the end of 10 months of operation, the company reported that 44% of orders wer
Statistics- Test of hypothesis: Assume that for a sample of 40 days during the first half of 2003, the daily audience was 612,000 viewers with a sample standard deviation of 65,000 viewers. a. Develop the hypotheses if CNN management would like information on any change in the CNN viewing audience. b. Determine the p-value.
AOL Time Warner Inc.'s CNN has been the longtime ratings leader of cable television news. Nielsen Media Research indicated that the mean CNN viewing audience was 600,000 viewers per day during 2002 (The Wall Street Journal, March 10, 2003). Assume that for a sample of 40 days during the first half of 2003, the daily audience was
Reis, Inc., a New York real estate research firm, tracks the cost of apartment rentals in the United States. In mid-2002, the nationwide mean apartment rental rate was $895 per month (The Wall Street Journal, July 8, 2002). Assume that, based on the historical quarterly surveys, a population standard deviation of s = $225 is rea
To determine confidence interval of mean and test if there is significant difference between means. See attached file for full problem description.
A) An iron foundry asserts that the mean weight of the castings it produces is 20.0 kg. The weights of a sample of 10- castings are: 19.8 20.3 20.6 21.1 19.3 19.6 20.1 20.8 21.1 21.3 Assuming that the weight of a casting has an approximately normal distribution, test whether or not the assertion is correct. b) The poli
1. The mean weight for a certain type of fish is known to be 28.0 ounces with a standard deviation of 2.5 ounces . A game warden catches and weighs 30 fish from a certqin pond to check if they are larger than the mean stated above. If the mean of the sample is 30.9 ounces is this evidence of a significantly larger population of
1.Why would you use a small sample to draw inference about a large population? Test of a single proportion: 2. What is the difference between a sample parameter (X-bar and s) and a proportion parameter (p)? Test of two populations, large sample size (z-statistics) 3. When would you use two population test with a larg
What are the 5 hypothesis steps? 1. 2. 3. 4. 5. 2. The management of White industries is considering a new method of assembling its golf cart. The present method requires 42.3 minutes, on the average, to assemble a cart. The mean assembly time for a random sample of 24 carts, using the new method, was 40.6 minutes, an
I'm having difficulty understanding hypothesis testing. I need some assistance putting together a hypothesis test for comparing 1970s gasoline prices and 2006 gasoline prices. I need to find out if they are actually higher overall now as compared to 30 years ago. What formula should I use? And how should I put it into the five-s
Please see the attached file. --- Question 12 Choose the statement that best applies to the following example and SPSS output. Dana wishes to assess whether vitamin C is effective in the treatment of colds. To evaluate her hypothesis she decides to conduct a 2-year experimental study. She obtains 30 volunteers from u
The question asks the appeal of audiotapes for walking tours of eight major cities. The issue is if all the tapes are equally appealing, and what is distinctive about the p-value. SSTR = 7,102 SSE = 10,511 r = 8 ni = 20 MSTR = SSTR/(r-1) = 7102/7 = 1014.57 MSE = SSE/(n-r) = 10,511/(160-8) = 69.15 F(7,152) = 14.67
The table below compares the prices of two online grocery stores. (see attached table) Using the table, which of the following is the correct calculation of the t statistic needed to test the null hypothesis that there is no difference in the average price of items at the two stores? A. -0.011 B. -0.541 C. -1.746
Assembly line workers are randomly assigned to two groups with 21 workers in each group. Each group receives a different training program and then their scores on an assembly task are compared. The "F" statistic for the variance in the two groups is 0.178. Using a 0.05 level of significance, what are the critical values for rej