Tully Tyres sells cheap imported tyres. The manager believes its profits are in decline. You have just been hired as an analyst by the manager of Tully Tyres to investigate the expected profit over the next 12 months based on current data.

•Monthly demand varies from 100 to 200 tyres – probabilities shown in the partial section of the spreadsheet below, but you have to insert formulas to ge the cumulative probability distribution which can be used in Excel with the VLOOKUP command.
•The average selling price per tyre follows a discrete uniform distribution ranging from $160 to $180 each. This means that it can take on equally likely integer values between $160 and $180 – more on this below.
•The average profit margin per tyre after covering variable costs follows a continuous uniform distribution between 20% and 30% of the selling price.
•Fixed costs per month are $2000.

(a)Using Excel set up a model to simulate the next 12 months to determine the expected average monthly profit for the year. You need to have loaded the Analysis Toolpak Add-In to your version of Excel. You must keep the data separate from the model. The model should show only formulas, no numbers whatsoever except for the month number.

The first random number (RN 1) is to simulate monthly demands for tyres.
•The average selling price follows a discrete uniform distribution and can be determined by the function =RANDBETWEEN(160,180) in this case. But of course you will not enter (160,180) but the data cell references where they are recorded.
•The second random number (RN 2) is used to help simulate the profit margin.
•The average profit margin follows a continuous uniform distribution ranging between 20% and 30% and can be determined by the formula =0.2+(0.3-0.2)*the second random number (RN 2). Again you do not enter 0.2 and 0.3 but the data cell references where they are located. Note that if the random number is high, say 1, then 0.3-0.2 becomes 1 and when added to 0.2 it becomes 0.3. If the random number is low, say 0, then 0.3-0.2 becomes zero and the profit margin becomes 0.2.
•Add the 12 monthly profit figures and then find the average monthly profit.

Show the data and the model in two printouts: (1) the results, and (2) the formulas. Both printouts must show the grid (ie., row and column numbers) and be copied from Excel and pasted into Word. See Spreadsheet Advice in Interact Resources for guidance.

(b)Provide the average monthly profit to Ajax Tyres over the 12-month period.

(c)You present your findings to the manager of Ajax Tyres. He thinks that with market forces he can increase the average selling price by $40 (ie from $200 to $220) without losing sales. However he does suggest that the profit margin would then increase from 22% to 32%.

He has suggested that you examine the effect of these changes and report the results to him. Change the data accordingly in your model to make the changes and paste the output in your Word answer then write a report to the manager explaining your conclusions with respect to his suggestions. Also mention any reservations you might have about the change in selling prices.

The report must be dated, addressed to the Manager and signed off by you.
(Word limit: No more than 150 words)

My factory makes thermometers and I am testing if they are accurate. I will test this by measuring the average temperatures of different thermometers in ice-water. The null hypothesis is that the true average reading of thermometers from this factory in ice-water is 0◦ against the two-sided alternative. I will construct a p-value. What will the value of the p-value mean? If you wish, you can pretend the value of the p-value will be 0.06.

Parking lots; A survey of autos parked in student and staff lots at a large university classified the brands by country of origin, as seen in the table

                               Driver

                       Student      Staff

American         104            105

European         33               11

Asian                55               48

a) What percentage of all cars surveyed wcre American?

b) What percentage of the American cars were owned by students?

c) What percen of the students owned American

d) What is the marginal distribution of origin ?

e) What is the condition of drivers American cars?

f) Do you think that the origin of the car is independent of the type of driver? Explain

A population proportion is 0.5. A sample of size 200 will be taken and the sample proportion will be used to estimate the population proportion. Use z-table.

Round your answers to four decimal places. Do not round intermediate calculations.

a. What is the probability that the sample proportion will be within +/-0.02 of the population proportion?

b. What is the probability that the sample proportion will be within +/-0.07 of the population proportion?

1. Using the 50-35-14-2 rule, sketch each of the distributions above.

2. For each variable, calculate the value of X at the 40^th %ile and the 61^nd %ile.

3. For each variable, calculate the %ile corresponding to a score of 4 on the variable.

4. 2013 SAT subscores for the nation are given below.

A) For the composite, what score do you need to qualify for Mensa, which requires you to be in the top 2% of the population?

B) Oddly enough, Phillip scored exactly 500 on each subscore… what percent of students scored higher in each subscore? What percent of students scored LOWER than his composite score of 1000?

C) MU admissions accept a 1080 composite score as sufficient to demonstrate potential success as a student. What percent of students qualify?

D) The MU honor’s college accepts incoming freshmen with a composite SAT of 1380 (if you were ALSO top 15%ile of high school class). What percent of students qualify with that composite score?

Can you create a pie chart for “Cigarettes”? If so, display it. If this cannot be created in Minitab, explain why.

Can you create a bar chart for “Cigarettes”? Is so, display it. If this cannot be created in Minitab, explain why.

Concerning the descriptive statistics for “Cigarettes,” what should “N*” or “N missing” be? (Minitab won’t tell you this answer, but you can figure it out.)

The speed with which utility companies can resolve problems is very important. GTC, the Georgetown Telephone Company, reports it can resolve customer problems the same day they are reported in 64% of the cases. Suppose the 15 cases reported today are representative of all complaints. a-1. How many of the problems would you expect to be resolved today? (Round your answer to 2 decimal places.) Number of Problems a-2. What is the standard deviation? (Round your answer to 4 decimal places.) Standard Deviation b. What is the probability 8 of the problems can be resolved today? (Round your answer to 4 decimal places.) Probability c. What is the probability 8 or 9 of the problems can be resolved today? (Round your answer to 4 decimal places.) Probability d. What is the probability more than 10 of the problems can be resolved today? (Round your answer to 4 decimal places.) Probability

In the M/M/1 system, derive P0 by equating the rate at which customers arrive with the rate at which they depart

Using the most appropriate type of graph to present weekly closing price of the Bitcoin and provide a general description. Hint: What are the main features of this graph, is there a trend? [Topic 1]                                  

Calculate the weekly return and construct a histogram. Does the data appear normally distributed?   Is there evidence of outliers? Hint: the formula for a return is (Current Price – Previous price)/Previous price multiplied by 100 [Topics 1-3]                                                         

Calculate and interpret the three aspects of Descriptive Analysis, Location, Shape and Spread, for weekly return. [Topic 1]

What is the empirical probability of a loss? [Topic 2]

Repeat the same steps (steps 1-4 above) for three share prices in the Australia Securities Exchange: BHP Billiton (BHP) from the mining sector, Commonwealth Bank of Australia (CBA) from the bank sector, and Telstra Corporation (TLS) from the telecom sector.

Construct a 95% confidence interval of the return to Bitcoin, and interpret the interval. How does your interval change if the level of confidence is 90% and 95% respectively, and explain why. [Topics 6-7]

Construct a 95% confidence interval of the return to BHP, CBA, and TLS respectively. [Topics 6-7]

An investment advisor claimed that the return to Bitcoin is 4% while the returns to other three shares are no different from zero. Do you agree? Justify your reasoning using a two-tailed hypothesis test approach at the significance level of 5%. [Topic 8]

4. The mean score on a standardized test is 540 with a standard deviation of 55. What percent of students taking the test scored above 625? (nearest hundredth)

5. True or False. A z-score is the number of standard deviations from the median.

6. True or False. A z-score cannot be negative.

7. True or False. If the standard deviation is small, the data values are very varied.

8. True or False.   The standard error of the mean is smaller than the standard deviation of the population.  

9. True or False.   The z a/2  value cannot be a negative number.

In a clinical​ trial, 20 out of 823 patients taking a prescription drug daily complained of flulike symptoms. Suppose that it is known that 1.9​% of patients taking competing drugs complain of flulike symptoms. Is there sufficient evidence to conclude that more than 1.9​% of this​ drug's users experience flulike symptoms as a side effect at the alpha equals 0.01 level of​ significance?

A medical researcher wants to compare the pulse rates of smokers and non-smokers. He believes that the pulse rate for smokers and non-smokers is different and wants to test this claim at the 0.05 level of significance. The researcher checks 72 smokers and finds that they have a mean pulse rate of 75, and 81 non-smokers have a mean pulse rate of 72. The standard deviation of the pulse rates is found to be 6 for smokers and 9 for non-smokers. Let μ1 be the true mean pulse rate for smokers and μ2 be the true mean pulse rate for non-smokers.

Step 1 of 4: State the null and alternative hypotheses for the test.

Step 2 of 4: Compute the value of the test statistic. Round your answer to two decimal places.

Step 3 of 4: Determine the decision rule for rejecting the null hypothesis H0H0. Round the numerical portion of your answer to two decimal places.

....reject H0 if

Step 4 of 4: Make the decision for the hypothesis test.

....reject null hypothesis...fail to reject null hypothesis

An agronomist is conducting a field experiment to identify the best management practice for minimizing spread of a certain plant disease in corn. He compares four different management strategies designed so that they would reduce the spread of the disease. He has set up a field study with a total of 25 experimental plots planted with corn and with 5 treatments (4 disease prevention treatments and a control treatment). Each treatment has been assigned to 5 randomly selected plots. Plant biomass was then measured from each plot at the end of the experiment. The ANOVA table and the treatment means are shown below.

ANOVA:

a)(10 points) Conduct all pairwise comparisons between the treatment means using LSD, (=0.05). Present the results using letters assigned to treatment means (Use letters in the column Letters for part a) in the below table)

b)(10 points) Conduct all pairwise comparisons between the treatment means using Tukey’s HSD (=0.05). Present the results using letters assigned to treatment means. (Use the column Letters for part b) in the below table)

                                                NAME:____________________________

c)(10 points) Did you expect to see differences in conclusions obtained using the two methods (LSD and Tukey’s)? Which method would you use for this analysis? For full credit, provide an explanationof your choice.

Step by step procedure by hand, possibly shortest way to go about this problem would be ideal. thank you in advance

3) Here are the weights (kg) of 15 male lions and 17 female lions (all adults). Construct a correct parallel boxplot for these data. males: 176.0 175.7 174.2 185.1 168.1 165.1 177.3 172.4 188.3 162.4 167.3 154.6 176.8 181.8 182.5 females: 105.8 98.1 128.3 114.7 113.6 135.0 125.3 113.5 110.7 109.2 104.1 153.4 105.2 130.4 129.8 111.6 135.0 PLOT ON PAPER PLEASE AND SHOW WORK