Get Instant Help From 5000+ Experts For
question

Writing: Get your essay and assignment written from scratch by PhD expert

Rewriting: Paraphrase or rewrite your friend's essay with similar meaning at reduced cost

Editing:Proofread your work by experts and improve grade at Lowest cost

And Improve Your Grades
myassignmenthelp.com
loader
Phone no. Missing!

Enter phone no. to receive critical updates and urgent messages !

Attach file

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Guaranteed Higher Grade!
Free Quote
wave

Use Excel to generate the probability distribution for a binomial random variable for which there are 1000 trials (n = 1000) and the probability of success is 0.7 (p = 0.7).

The 2010 U.S. Census asked every household to report information on each person living there. Suppose for a sample of 30 households selected, the number of persons living in each was reported as follows.

 2       3        1        2         6         4         2        1        5        3         2        3        1        2         2      1       3        1       2       2       4        2         1         2          8            3           2          1         1        3

  1. Calculate the mean and median. What information do you obtain from these two values Does one seem more appropriate than the other for this sample
  2. Calculate the variance and standard deviation. What do these statistics reveal

According to the Consumer Electronics Manufacturers Association, 10% of all U.S. households have a fax machine and 52% have a personal computer. Suppose 91% of all U.S. households having a fax machine have a personal computer. A U.S. household is randomly selected.

  1. What is the probability that the household has a fax machine and a personal computer
  2. What is the probability that the household has a fax machine or a personal computer
  3. What is the probability that the household has a fax machine and does not have a personal computer
  4. What is the probability that the household has neither a fax machine nor a personal computer.
  • Mean and median

Mean = sum of data points/ sample size (n) = 75/30 = 2.50

Median

Sort the data in ascending order

Sample size = 30 (even number)

The mean and median are representative of the central tendency of the given data and highlights the average number of people in a household. Considering that the data may contain outliers in the form of household with 6 and 8 members, it would be appropriate to use median instead of mean as the mean may be influenced by extreme values which is not the  case for median.

  • Variance and standard deviation

Standard deviation  

The above statistics reveal the dispersion in the data and the deviation of the data points from the average value.

Percentage of US households has fax machine = 10%

Percentage of US households has personal computer= 52%

Percentage of US households has fax machine and has personal computer P(PC| Fax) =91%

Joint probability table can be formed based on the above shown probabilities

US household has fax /PC

Fax yes

Fax no

Total

PC yes

0.091

0.429

0.52

PC no

0.009

0.471

0.48

Total

0.10

0.90

1.0

  • Probability that a randomly selected US household would has a fax machine and a personal computer 
  • Probability that a randomly selected US household would has a fax machine or a personal computer
  • Probability that a randomly selected US household would has a fax machine and does not have a personal computer
  • Probability that a randomly selected US household would has neither a fax machine nor a personal computer.
Cite This Work

To export a reference to this article please select a referencing stye below:

My Assignment Help. (2021). Using Excel To Generate Probability Distribution For A Binomial Random Variable And Analyzing Data On Household Size And Computer Usage In The US. Retrieved from https://myassignmenthelp.com/free-samples/stat220-business-statistics/central-tendency.html.

"Using Excel To Generate Probability Distribution For A Binomial Random Variable And Analyzing Data On Household Size And Computer Usage In The US." My Assignment Help, 2021, https://myassignmenthelp.com/free-samples/stat220-business-statistics/central-tendency.html.

My Assignment Help (2021) Using Excel To Generate Probability Distribution For A Binomial Random Variable And Analyzing Data On Household Size And Computer Usage In The US [Online]. Available from: https://myassignmenthelp.com/free-samples/stat220-business-statistics/central-tendency.html
[Accessed 13 November 2024].

My Assignment Help. 'Using Excel To Generate Probability Distribution For A Binomial Random Variable And Analyzing Data On Household Size And Computer Usage In The US' (My Assignment Help, 2021) <https://myassignmenthelp.com/free-samples/stat220-business-statistics/central-tendency.html> accessed 13 November 2024.

My Assignment Help. Using Excel To Generate Probability Distribution For A Binomial Random Variable And Analyzing Data On Household Size And Computer Usage In The US [Internet]. My Assignment Help. 2021 [cited 13 November 2024]. Available from: https://myassignmenthelp.com/free-samples/stat220-business-statistics/central-tendency.html.

Get instant help from 5000+ experts for
question

Writing: Get your essay and assignment written from scratch by PhD expert

Rewriting: Paraphrase or rewrite your friend's essay with similar meaning at reduced cost

Editing: Proofread your work by experts and improve grade at Lowest cost

loader
250 words
Phone no. Missing!

Enter phone no. to receive critical updates and urgent messages !

Attach file

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Plagiarism checker
Verify originality of an essay
essay
Generate unique essays in a jiffy
Plagiarism checker
Cite sources with ease
support
close