Question

In: Statistics and Probability

Problem 5 Along these same lines, the trucks used to deliver items were “gently” used when...

Problem 5

Along these same lines, the trucks used to deliver items were “gently” used when Frankie first purchased them, and that was 10 years ago. They have been kept up with routine maintenance, but problems seem to be happening with frightening regularity recently. The tab “Break downs” contains records of how many trucks broke down per week, how much a break down costs, and the amount it would cost to replace the truck with a newer model. Determine the amount that OESCo is currently spending to repair their trucks, and consequently if it makes sense to upgrade the fleet of trucks.

Week Beginning 1-Oct 8-Oct 15-Oct 22-Oct 29-Oct 5-Nov 12-Nov 19-Nov 26-Nov 3-Dec 10-Dec 17-Dec 24-Dec 31-Dec 7-Jan 14-Jan 21-Jan 28-Jan 4-Feb 11-Feb 18-Feb 25-Feb 4-Mar 11-Mar 18-Mar 25-Mar
No. of Break Downs 0 2 0 0 1 0 0 1 0 0 0 2 2 1 1 2 1 0 1 1 2 2 0 2 0 2
Cost per Breakdown $500
Break Downs per Week  
Break Down Cost per Week
Cost per Week to Upgrade Fleet $633
Worth it to Upgrade?

Use Excel, show formulas you used in highlighted cells.

Solutions

Expert Solution

Note : The problem is solved with available data. Please use the same formula with more data but change the range in the cells.

orchestra answered 2 years ago
Next > < Previous

Related Solutions

Keith’s Florists has 16 delivery trucks, used mainly to deliver flowers and flower arrangements in the...
Keith’s Florists has 16 delivery trucks, used mainly to deliver flowers and flower arrangements in the Greenville, South Carolina, area. Of these 16 trucks, 6 have brake problems. A sample of 5 trucks is randomly selected. What is the probability that 2 of those tested have defective brakes? (Round your answer to 4 decimal places.)
Problem 3: Food Prices: Target versus Safeway.  Grocery prices of the same randomly selected items were collected...
Problem 3: Food Prices: Target versus Safeway.  Grocery prices of the same randomly selected items were collected and compared from Target and Safeway.  Imagine you were interested in conducting a hypothesis test to determine whether the mean prices were significantly different.  Note: to answer the questions below, subtract Target price – Safeway price (i.e. subtract Safeway price from Target price). Data: Mean = -0.5071, Standard Deviation = 0.9012 Ball Park Hot Dogs 3.79 3.79 0 Milk Gallon 2.79 2.99 -0.2 Tomato Sauce 16...
    Records of 40 used passenger cars and 40 used pickup trucks were randomly sampled to investigate...
    Records of 40 used passenger cars and 40 used pickup trucks were randomly sampled to investigate           whether there was any significant difference in the mean time in years that they were kept by the original           owner before being sold.  For the sampled cars, the mean was 5.3 years with a standard deviation of 2.2           years.  For the sampled pickup trucks, the mean was 7.1 years with a standard deviation of 3.0 years.             (Assume that the two samples are independent.) a)  Construct and interpret...
To create the following problem the other problem with all samples n =5; the same sample...
To create the following problem the other problem with all samples n =5; the same sample means and variances that appeared in the problem were used but the sample size was doubled to n = 10. Treatment I II III n = 10 n = 10 n = 10 N = 30 M =1 M = 5 M = 6 T = 10 T= 50 T = 60 G =120 s2 = 9.00 s2 = 10.00 s2 = 11.00 Σx2...
What is an inherent problem to watch out for when adding transient suppressors to data lines?
What is an inherent problem to watch out for when adding transient suppressors to data lines?
Consider the knapsack problem with the capacity C = 8 and 5 items with weights 6,...
Consider the knapsack problem with the capacity C = 8 and 5 items with weights 6, 4, 3, 7, 1. Find which items will exactly fill the knapsack using dynamic programming solution introduced in class. Show all your work. use I/O knapsack
You are again given the same 5 observations that you were provided with in the Correlation...
You are again given the same 5 observations that you were provided with in the Correlation problem.However,you are now asked to derive the regression line,y’= a+bX for the data below.After you have calculated the regression equation,explain to me how you could use it.                                X(Independent Variable) Y(Dependent variable) Month Advertising Expenditure (in Millions of $) Sales Revenue (in Millions of $)        July 1 3 August 2 7 September 3 5 October 4 11 November 5 14 12-Calculating the Standard Error of...
You are again given the same 5 observations that you were provided with in the Correlation...
You are again given the same 5 observations that you were provided with in the Correlation problem.However,you are now asked to derive the regression line,y’= a+bX for the data below.After you have calculated the regression equation,explain to me how you could use it.                                X(Independent Variable) Y(Dependent variable) Month Advertising Expenditure (in Millions of $) Sales Revenue (in Millions of $)        July 1 3 August 2 7 September 3 5 October 4 11 November 5 14 Calculating the Standard Error of...
Write up to 4 or 5 lines to explain the logic used behind those codes. Separately...
Write up to 4 or 5 lines to explain the logic used behind those codes. Separately for each please 1) #include <iostream> #include <string> #include <fstream> #include <vector> #include <sstream> using namespace std; int main() {         ifstream infile("worldpop.txt");         vector<pair<string, int>> population_directory;         string line;         while(getline(infile, line)){                 if(line.size()>0){                         stringstream ss(line);                         string country;                         int population;                         ss>>country;                         ss>>population;                         population_directory.push_back(make_pair(country, population));                 }         }         cout<<"Task 1"<<endl;         cout<<"Names of countries with population>=1000,000,000"<<endl;...
Please outline each step used along the way to solve the problem using excel only with...
Please outline each step used along the way to solve the problem using excel only with cell numbers and formulas used. Thank you. Whenever an Alliance Air customer flies on a prepurchased seat, Alliance Air obtains $100 in profits. However, if Alliance Air has more customers seeking a seat then they have prepurchased, Alliance Air is forced to book that passenger on a seat purchased that day. In such a situation, Alliance Air has a profit of -$170 due to...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT