A random sample of six cars from a particular model year had the following fuel consumption figures (in miles per gallon). Find the 98% confidence interval for the true mean fuel consumption for cars of this model year.
Sample Data
18.6
19.3
19.4
19.8
19.6
19.7
What is the left and right endpoint? Please help
In: Statistics and Probability
1.The notion of sustainability is used differently in economics than in the natural sciences. Explain the meaning of sustainability in these two frameworks, and discuss the attempts that have been made by economists to make the concept operational.
2. Would the extension of territorial limits for fishing beyond 200 miles from coastlines offer the prospect of significant improvements in the efficiency of commercial fishing
In: Economics
1.The notion of sustainability is used differently in economics than in the natural sciences. Explain the meaning of sustainability in these two frameworks, and discuss the attempts that have been made by economists to make the concept operational.
2. Would the extension of territorial limits for fishing beyond 200 miles from coastlines offer the prospect of significant improvements in the efficiency of commercial fishing
In: Economics
The cost per seat-mile on a major U.S. airline is 24.1 cents. In order to estimate the cost of flying a passenger from Pensacola, FL, to Denver, CO, we should multiply 1,184 miles by 24.1 cents.
Do you agree or disagree? Explain your reasoning.
What would you suggest to estimate the cost of a flight?
In: Accounting
The Problem involves building a 12 – foot diameter sewer at a bottom depth of 40 feet in loose sand with a water table at a depth of 8 feet. The alignment is along city streets. The project needs to be completed in 800 days. Determine the amount and types of equipment you feel should be used on this project. The sewer is ten miles in length.
In: Civil Engineering
Using R Studio/R programming...
A consumer-reports group is testing whether a gasoline additive
changes a car's gas mileage. A test of seven cars finds an average
improvement of 0.4 miles per gallon with a standard deviation of
3.57. Is the difference significantly greater than 0? Assume that
the values are normally distributed.
What would the code be?
In: Statistics and Probability
uide to marks: 20 marks – 12 for a, 2 for b, 6 for c
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.
You can use this partial template to guide you:
| Ajax Tyres | |||||||
| DATA | |||||||
| Prob | Cummulative prob | Demand | Selling | Price | $160 | $180 | |
| 0.05 | 100 | Monthly | Fixed cost | $2,000 | |||
| 0.10 | 120 | Profit | Margin | 20% | 30% | ||
| 0.20 | 140 | ||||||
| 0.30 | 160 | ||||||
| 0.25 | 180 | ||||||
| 0.10 | 200 | ||||||
| 1.00 | |||||||
| MODEL | |||||||
| Selling | Profit | Fixed | |||||
| Month | RN1 | Demand | Price | RN2 | Margin | Costs | Profit |
| 1 | 0.23297 | #N/A | $180 | 0.227625 | 0.2 |
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)
In: Statistics and Probability
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.
| Tully Tyres | |||||||
| Data | |||||||
| Probability | Cumulative Prob | Demand | Selling price | $160 | $180 | ||
| 0.05 | 100 | Monthly fixed cost | $2000 | ||||
| 0.10 | 120 | Profit margin | 20% | 30% | |||
| 0.20 | 140 | ||||||
| 0.30 | 160 | ||||||
| 0.25 | 180 | ||||||
| 0.10 | 200 | ||||||
| 1 | |||||||
| Model | |||||||
| Month | RN1 | Demand | Selling price | RN2 | Profit margin | Fixed cost | Profit |
| 1 | 0.23297 | #N/A | $180 | 0.227625 | 0.2 | ||
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)
In: Math
The Carbondale Hospital is considering the purchase of ambulance. The TheXarbondale Hospital is considering the purchase of ambulance. The decision will rest partly on the anticipated mileage" be driven next year. The miles driven during the past 5
years are as follows:
|
Year |
Mileage |
|
1 |
3000 |
|
2 |
4000 |
|
3 |
3400 |
|
4 |
3800 |
|
5 |
3700 |
a) Forecast the mileage for next year using a 2-year moving average.
b) Find the MAD based on the 2-year moving average forecast in part (a), (Hint: You will have only 3 years of matched data.)
c) Use a weighted 2-year moving average with weights of .4 and .6 to forecast next year's mileage. (The weight of .6 is for the most recent year.) What MAD results from using this approach to forecasting? (Hint: You will have only 3 years of matched data.)
d) Compute the forecast for year 6 using exponential smoothing, an initial forecast for year 1 of 3,000 miles, and a = .5.
*****PLEASE SHOW WORK
In: Other
| Buffalo | Boston |
| 26 | 23 |
| 27 | 14 |
| 39 | 11 |
| 23 | 19 |
| 17 | 19 |
| 16 | 4 |
| 21 | 9 |
| 31 | 12 |
| 1 | 12 |
| 23 | 7 |
| 32 | 32 |
| 32 | 26 |
| 24 | 21 |
| 42 | 16 |
| 38 | 16 |
| 29 | 18 |
| 16 | 16 |
| 12 | 20 |
| 29 | 20 |
| 16 | 11 |
| 18 | 10 |
| 27 | 18 |
| 2 | 11 |
| 21 | 17 |
| 35 | 20 |
| 21 | 20 |
| 29 | 25 |
| 24 | 16 |
| 17 | 17 |
| 21 | 8 |
| 38 | |
| 21 | |
| 9 | |
| 24 | |
| 31 | |
| 26 | |
| 16 | |
| 27 | |
| 24 | |
| 18 | |
| 24 | |
| 17 | |
| 13 | |
| 15 | |
| 21 | |
| 21 | |
| 21 | |
| 32 | |
| 27 | |
| 35 |
Round your answers to one decimal place.
What is the point estimate of the difference between the mean number of miles that Buffalo residents travel per day and the mean number of miles that Boston residents travel per day?
What is the 95% confidence interval for the difference between the two population means?
In: Statistics and Probability