Logo
Home Study Material Contact Search
AI Chat FREE
  1. mathematics
  2. basic math
  3. can someone show me how to do this on excel? quest

Can someone show me how to do this on excel? Question involves cell phone users. Mean monthly data...

50.1K

Verified Solution

Question

Basic Math

Can someone show me how to do this onexcel?

Question involves cell phone users.

Mean monthly data usage = 5.8 GB/month

StDev monthly data usage = 2.5 GB/month

"Heavy users" are those that use >= 9 GB/month

a.) What is the probability a "heavy user" uses more than 10GB/month?

b.) Two users are selected at random. What is the probability atleast one of them is a heavy user?

c.) Five users are selected at random. What is the probabilitythat at least one of them is a heavy user?

Again, I am looking for the EXCEL formula to solve these. THANKYOU!!!!

Answer & Explanation Solved by verified expert
4.0 Ratings (829 Votes)
we have GivenMean monthly data usage 58 GBmonthStDev monthly data usage 25 GBmontha What is the probability a heavy user uses more than 10GBmonthlet xheavy userpx1mean58sd25probability of havey user0025263b Two users are selected at    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Statistics
1.2K views

20 30 40 76 70 61 50 data 60 70 Based on the box plot...

Geometry
1.2K views

Given: Rectangle ABCDProve: AC=BD

Medical Sciences
1.2K views

Matching Match the endocrine term in column I with the correct description in column II.               Column I Column II 1. _____________...

Accounting
1.2K views

Multiple-Step Income Statement and Report Form of Balance Sheet The following selected accounts and their current balances appear...

Biology
1.2K views

Some members of a population have traits that make them more likely to survive than...

Biology
1.2K views

References Course Handout 2 LRS 2018 Chapter 2 Exploring Relationsh

Biology
1.2K views

For transmembrane proteins, which of the following properties is NOTCORRECT?They have hydrophobic a-helices or -sheets...

Accounting
1.2K views

Find an article on an employee's need for "soft skills" and strong communication skillsin...

Accounting
1.2K views

Shown below is activity for one of the products of Denver Office Equipment: ...

Accounting
1.2K views

Yancey Productions is a film studio that uses a job-order costing system. The company's direct...

Accounting
1.2K views

Represent the following information as a pictogram. Age Purchase...

Finance
1.2K views

(a) Develop proforma Project Income Statement Using Excel Spreadsheet (b) Compute Net Project Cash flows,...