ZuoTi.Pro
Question
solve it by using Microsoft Excel, please provide detailed steps on how you used excel tools.
Thanks!
Q 1. The following data represents the hours of operation to failure of 50 light bulbs: 310 55 311 327 340 245 20 256 316 331
math   Advanced-Math   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

(a) Role of Measures of central trendency in explaining data Sum of data set a Mean (OR) all values in a Number of values Aveb) Role & Measude o dispersion in explaining the data: Kange = largest observation - Smallest obsovation = 369.0 Advantage :and Box whiskes (c) Graphical presentation by histogram plot. Frequency 80 160 200 320 400400- 300- 200 + CI 100-4the assumption of normality nd 95% CI of (d) Test mean M 95% confidence Intesual = 95% CI = (261. 6,304.6)Probability Plot of C1 Normal Mean StDev 283.1 83.24 60 AD 3.926 P-Value <0.005 Percent 096 100 200 300 400 500 .00

0 0
Add a comment
Know the answer?
Add Answer to:
solve it by using Microsoft Excel, please provide detailed steps on how you used excel tools....
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

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

  • [The following information applies to the questions displayed below.] An air-conditioning repair department manager has compiled...

    [The following information applies to the questions displayed below.] An air-conditioning repair department manager has compiled data on the primary reason for 41 service calls for the previous week, as shown in the table. Job Number 301 302 303 304 305 306 307 308 309 310 311 312 313 314 Problem/ Customer Type N/C N/R N/R N/C F/R F/R N/C o/c F/R o/c w/c W/R N/R o/c Job Number 315 316 317 318 319 320 321 322 323 324 325...

  • 33 On May 6, Jim Ryan borrowed $14,000 from Lane Bank at 7 % interest. Jim...

    33 On May 6, Jim Ryan borrowed $14,000 from Lane Bank at 7 % interest. Jim plans to repay the loan on March 11. Assume the loan is on ordinary interest. How much will Jim repay on March 11? (Use Days in a year table) (Round your answer to the nearest cent.) Jm repay etbook 7-1 TABLE Exact days-in-a-year calendar (excluding leap year)" Day of month 30 31 30 31 28 31 30 31 31 30 31 31 Dec Mar...

  • An air-conditioning repair department manager has compiled data on the primary reason for 41 service calls...

    An air-conditioning repair department manager has compiled data on the primary reason for 41 service calls for the previous week, as shown in the table. Job Number Problem/ Customer Type Job Number Problem/ Customer Type Job Number Problem/ Customer Type 301 F/R 315 F/C 329 O/C 302 O/R 316 O/C 330 N/R 303 N/C 317 W/C 331 N/R 304 N/R 318 N/R 332 W/R 305 W/C 319 O/C 333 O/R 306 N/R 320 F/R 334 O/C 307 F/R 321 F/R...

  • For this assignment, you will design tow classes that work together to simulate a car's fuel...

    For this assignment, you will design tow classes that work together to simulate a car's fuel gauge and odometer. The classes you will design are the following: 1. The FuelGauge Class: This class will simulate a fuel gauge. Its responsibilities are: To know the car's current amount of fuel, in gallons. To report the car's current amount of fuel, in gallons. To be able to increment the amount of fuel by one gallon. This simulates putting fuel in the car....

  • 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);     }         /*...

  • Hi it's python I imported a data which are so many words in txt and I arranged and reshaped with ...

    Hi it's python I imported a data which are so many words in txt and I arranged and reshaped with alphabetically both rows and columns I was successful with these steps but I am stuck with next step below is my code and screenshot import numpy as np import pandas as pd data=pd.read_csv("/Users/superman/Downloads/words_file2.txt",header=None) df_input=pd.DataFrame(data) df_output=pd.DataFrame(np.arange(676).reshape((26,26)), index = ['a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z'], columns = ['a','b','c','d','e','f','g','h','i','j','k','l','m','n','o','p','q','r','s','t','u','v','w','x','y','z']) df_output.index.name="Start" df_output.columns.name="End" df_output This below screen shot is what I have to find I have to find each word...

  • On the following code there is an error bc you are not reverting back to the...

    On the following code there is an error bc you are not reverting back to the original order after a sort. For the next sort you are passing the same reference variable to the next method. But that will point to the same (already sorted) array on the memory. Hence after the first sorting method, all three sorting methods are working on the already sorted array. Do the following : Just copy each data set to 4 different arrays -...

  • Database Intro Salesmen Sheet Order_info Sheet Business_Info sheet 1.Create your own table design based on the...

    Database Intro Salesmen Sheet Order_info Sheet Business_Info sheet 1.Create your own table design based on the Excel data, and include all relationships (joins). Apply referential integrity rules wherever appropriate. Import the data from Excel to Access to populate tables: 1. Use the Chen technique and illustrate the E-R diagram for the tables you created Note: It may be necessary to change the data composition due to normalization issues, if you change the composition detail how and why; (you may find...

  • If the two signal handling functions in 3000pc were replaced by one function, would there be...

    If the two signal handling functions in 3000pc were replaced by one function, would there be any significant loss of functionality? Briefly explain /* 3000pc.c */ 2 3 4 5 6 7 8 #include <stdio.h> 9 #include <stdlib.h> 10 #include <unistd.h> 11 #include <sys/mman.h> 12 #include <errno.h> 13 #include <string.h> 14 #include <sys/types.h> 15 #include <sys/wait.h> 16 #include <semaphore.h> 17 #include <string.h> 18 #include <time.h> 19 20 #define QUEUESIZE 32 21 #define WORDSIZE 16 22 23 const int wordlist_size =...

  • Please determine the IDENTITY of the unknown compound and explain how each peak / data point...

    Please determine the IDENTITY of the unknown compound and explain how each peak / data point from the following instruments led to that identification. What does the gcms indicate. Thank you very much! (The GCMS data is just a long set of numbers which is why the question appears so long). IR of unknown: NMR unknown Proton Graphs (first is overall graph, others that follow are zoomed in sections): NMR unknown Carbon Graphs (first is overall graph, others that follow...

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