Question

(All in Excel) See the population data for Buena School District buses such as: a) Determine...

(All in Excel) See the population data for Buena School District buses such as:
a) Determine the size of a sample of average bus maintenance, at a confidence level of 95% and with an estimated error of $ 25.
b) Construct the 95% confidence interval of the average maintenance of the buses.
c) Construct the confidence interval of 90% of the average mileage of the buses.
Maintenance
329
503
505
466
359
546
427
474
382
422
433
474
558
561
357
329
497
459
355
489
436
455
514
503
380
432
478
406
471
444
493
452
461
496
469
442
414
459
457
462
570
439
369
390
469
381
501
432
392
441
448
468
467
478
515
411
504
504
392
423
410
529
477
540
450
390
424
433
428
494
396
458
493
475
476
403
337
492
426
449
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Step 1 : Find the mean and std. deviation for the maintenance variable.

00 D E F G H A 1 Maintenance 2 329 3 503 Mean 450.2875 =AVERAGE(A2:A81) Std. Deviation 53.34937 ESTDEV.P(A2:A81) N 80 =COUNT(

a) Determine the size of a sample of average bus maintenance, at a confidence level of 95% and with an estimated error of $ 25.
standard deviation = 0 = 53.34 margin of error = ME = 25 We need to find the sample size (n) Confidence interval = 0.95 alpha
b) Construct the 95% confidence interval of the average maintenance of the buses.

We are given sample mean = ju= 450.2875 standard deviation = 53.3437 Confidence interval = 0.95 a/2 = (1-0.9572= 0.025 Using

c. Data not give for the mileage variable

Add a comment
Know the answer?
Add Answer to:
(All in Excel) See the population data for Buena School District buses such as: a) Determine...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Part (a)    Using the THE TABLE BELOW that is posted with the assignment, carry out...

    Part (a)    Using the THE TABLE BELOW that is posted with the assignment, carry out a “t-test: Two-Sample Assuming Unequal Variances” in Excel (with α = 0.05) that tests whether there is a difference in mean maintenance costs between buses with Diesel engines and those with gasoline engines. using Excel file include the output as part of the answer Part (b)    Based on the t-test, what is your decision (“reject” or “do not reject”) regarding the null hypothesis...

  • (All in Excel) See the population data for Buena School District buses such as: c) Construct...

    (All in Excel) See the population data for Buena School District buses such as: c) Construct the confidence interval of 90% of the average mileage of the buses. Miles 853 883 822 865 751 870 780 857 818 869 848 845 885 838 760 741 859 826 806 858 785 828 980 857 803 819 821 798 815 757 1008 831 849 839 812 809 864 859 815 799 844 832 842 792 775 882 874 837 774 823 790...

  • Excel Problem (to be used with the data in the Excel file): Namata Appliances sells refrigerators....

    Excel Problem (to be used with the data in the Excel file): Namata Appliances sells refrigerators. The model seen in the data file is relatively inexpensive. Weekly demand for this model is relatively stable though there is enough variation to challenge management at Namata. Sometimes demand is lower than forecast, so that inventory costs are high. Other times the forecasts are too low. When this happens, on-hand inventory is not sufficient to meet customer demand and Namata requires expedited shipments...

  • LAB8.DAT IS LISTED BELOW 154    -6   279   215   404   391  -166   199  -302  -469   244    &n

    LAB8.DAT IS LISTED BELOW 154    -6   279   215   404   391  -166   199  -302  -469   244     0   -20   405   110   118   359   305    77  -317  -260   387  -471   -10  -332   479   213     0   -29  -440   182  -458  -429    22  -403   318   318   222  -350   160    19   473   149   300   -46   -68   325  -417  -367  -327  -109   331   303  -440  -101    27   -83   157   128  -208   -68  -485   484  -333 -394  -128  -302   -10  -161   452   420  -447   238  -231   -77    48   443   -82   483  -199   201   166    39   198   167  -322  -372   499  -329  -467    61   382   169  -310  -131   -39   482  -344   356   145  -124  -309   -72   -18  -379    90  -274  -115    83  -248  -210   117  -235   324   483   230  -156    84  -392   406   380   318  -239    94  -477   -75  -187  -339 -321   -77  -406    99   -29   196   200   139  -466  -431  -180    31   154   -92   320   218   469    31  -175  -394   111   279   -77  -409  -234  -346  -219   -60    27   -43   375    18   444   138   458  -259   176  -211   172   195  -432  -245  -276   168   344  -156   281   175  -493   102  -113   416  -499   -38   -76   -39   270  -178   285   -29  -464  -324   222   -27 -347  -159   107  -308   238  -257   417  -231   266  -311  -213  -409    76   183    47   -74   144   148   179   136   445  -291   209  -264  -381   107   -50   -41   162   270  -150   162   -84   342   333  -244   113    82    41   370  -235  -182  -381   440   146   -21   139    45   147    44   221    22   494  -281  -394  -390  -436   -95   -52  -134   264   128   272   433 473  -308  -361   196  -406    25    30   361   -15  -107   171   241    20  -152  -350 Goals: Practicing arrays and functions Create a program that will read values from a file called Lab8.dat (posted on Canvas) and store it into an array using a function other than main. The number of values in the file is less than 300 and all the values are whole numbers. The actual number of values stored in the file should be returned to the function call Your program should contain another...

  • need help to complete this java program // add appropriate import statements here. // These imports...

    need help to complete this java program // add appropriate import statements here. // These imports you can leave as is. import javafx.application.Application; import javafx.scene.Group; import javafx.scene.Scene; import javafx.scene.canvas.Canvas; import javafx.scene.canvas.GraphicsContext; import javafx.scene.paint.Color; import javafx.stage.Stage; /** @author yourAccountNameHere */ public class ConnectTheDots extends Application {            /*     * Do not add code to main(). Add it below in connectTheDots instead.     */     public static void main(String[] args) {         launch(args);     }         /*...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT