ZuoTi.Pro
Question

Suppose I have bank balances for a sample of ten thousand customers stored in an Excel spreadsheet. What function would I use
math   Statistics-And-Probability   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

calculate no one more on use average function option fo Scanned with Camscanner

0 0
Add a comment
Know the answer?
Add Answer to:
Suppose I have bank balances for a sample of ten thousand customers stored in an Excel...
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

  • 3. Suppose we are interested to study the number of customers arriving at a bank in...

    3. Suppose we are interested to study the number of customers arriving at a bank in a random work day. Previously we learned that the average number of customers per day is 100. (a) Define a random variable X for the number of customers arriving in a random work day. (b) Find the probability mass function. (c) Computer the probability that there will be at least 75 customers arriving at a random work day. (d)Derive the expected value (mean) of...

  • 1. A bank has kept records of the checking balances of its 4000 customers and determined...

    1. A bank has kept records of the checking balances of its 4000 customers and determined that the average daily balance of its customers is $300 with a standard deviation of $48. A random sample of 144 checking accounts is selected. Please answer the following questions. (a) What is the probability that the sample mean will be more than $309? (b) What is the probability that the sample mean will be between $293 and $307? (c) Suppose the number of...

  • 3. Suppose we have the following values for a different random variable X: 269.417 284.218 229.319...

    3. Suppose we have the following values for a different random variable X: 269.417 284.218 229.319 236.559 229.787 237.651 248.699 224.536 2 Use Excel to fill in the values of descriptive statistics below (attach a copy of your Excel spreadsheet printout). Mean: Sample Variance: Median: Skewness: 4. Use Excel to check your answer on correlation for question 2 part b. Attach a copy of your Exce spreadsheet printout.

  • (d) Suppose you have information about average heights of a random sample of airline passengers. The...

    (d) Suppose you have information about average heights of a random sample of airline passengers. The mode is 66 inches, the median is 69 inches, and the mean is 69 inches. To convert the data into centimeters, multiply each data value by 2.54. What are the values of the mode, median, and mean in centimeters? (Enter your answers to two decimal places.) mode cm median cm mean cm

  • 3. Waiting times​ (in minutes) of customers in a bank where all customers enter a single...

    3. Waiting times​ (in minutes) of customers in a bank where all customers enter a single waiting line and a bank where customers wait in individual lines at three different teller windows are listed below. Find the mean and median for each of the two​ samples, then compare the two sets of results. Single Line 6.36.3 6.66.6 6.76.7 6.86.8 6.96.9 7.17.1 7.67.6 7.87.8 7.87.8 7.87.8 Individual Lines 4.14.1 5.55.5 6.06.0 6.16.1 6.26.2 7.87.8 7.87.8 8.78.7 9.29.2 10.010.0 The mean waiting...

  • How do I do this in Excel? Business has about 20 customers a day with standard...

    How do I do this in Excel? Business has about 20 customers a day with standard deviation of 6 customers. Assume normal distribution. In an attempt to increase the number of customers, manger offers a $2 discount on 10 consecutive weekdays. Reports strategy works since sample mean of customers during the 10 days period jumps to 25. a. What is the probability of getting a sample average of 25 or more even if the manager does not offer the discount?...

  • Patty, a branch manager of a bank, would like a quick estimate of the mean checking account balance of all checking account customers. A random sample of checking 32 account balances results in a sample mean of $312,590.50 and a standard deviation of $52,

    Patty, a branch manager of a bank, would like a quick estimate of the mean checking account balance of all checking account customers. A random sample of checking 32 account balances results in a sample mean of $312,590.50 and a standard deviation of $52,100. Calculate and interpret a 95% confidence interval for the mean checking account balance. Round off all answers to two decimal places with complete solutions.

  • please I need help with excel or matlab part. part 3 Lab 1 BASIC DATA PROCESSING...

    please I need help with excel or matlab part. part 3 Lab 1 BASIC DATA PROCESSING PRE-LAB ASSIGNMENT 1. Read the lab manual carefully so you know what you have to do when you walk into the lab. 2. In a lab, the resistance of a resistor was measured using 50 samples giving the following values: 119.95 (6), 121.32 (5), 119.57 (7), 117.43(1), 120.76 (15), 120.67 (1), 119.78 (8), 121.43(3), 121.82(1), and 118.47 (3) 2 Estimate the average value of...

  • Consider a sample with data values 53, 55, 70, 58, and 64. Use Excel to compute...

    Consider a sample with data values 53, 55, 70, 58, and 64. Use Excel to compute the following quantities. (a) Compute the mean. (b) Compute the median. (c) Compute the range. (d) Compute the variance. (e) Compute the standard deviation. (f) Compute the z-score for each of the five observations

  • I have attached the data from the excel spreadsheet. 1 - 31. please show all work....

    I have attached the data from the excel spreadsheet. 1 - 31. please show all work. UUUUUUUUUU TULUNUM i 9.35 Experian Marketing Services reported that the typical Amer- ican spends a mean of 144 minutes (2.4 hours) per day accessing the Internet via a mobile device. (Source: The 2014 Digital Mar keter, available at ex.pn/1kXJjfX.) In order to test the validity of this statement, you select a sample of 30 friends and family. The results for the time spent per...

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