Question
Assume the YTD Sales are normally distributed with average and standard deviation approximated by the average and standard deviation of the sample in this project.
Assume the YTD Sales are normally distributed with average and standard deviation approximated by the average and standard deviation of the sample in this project. Extract the list of customers whose Balance Owed by Customers are between top 15 percentile and top 5 percentile of the sample and whose sales reps are either SR1 or SR4 with YTD Sales higher than the third quartile of the sample. Print field names and cell formulas in all the criterion sections and the list on two separate sheets.
A B C D E
1 Customer State Sales Rep Balance Owed by Customers YTD Sales
2 Good Samaritan Hospital RI SR4 12,647.10 59,500.00
3 Nepco Labs VT SR4 3,274.25 6,866.25
4 St. Johns Hospital CA SR4 15,623.87 53,234.51
5 EMG & EEG Labs MA SR4 12,583.97 31,685.19
6 Oaklawn Pharmacy RI SR4 4,513.21 5,176.26
7 Mercys Hospital NH SR4 520.65 32,760.00
8 Kathys Clinic CA SR4 11,318.97 25,358.74
9 Hope Hospital MA SR4 37,500.45 45,238.75
10 Quincy Lab MA SR4 21,565.00 40,540.00
11 St. Lukes Clinic RI SR4 13,290.62 61,023.90
12 St. Josephs Hospital CA SR3 47,113.50 64,000.00
13 Cape Psych Center MA SR3 31,509.10 55,173.24
14 New Life Clinic CA SR3 21,620.39 46,209.81
15 Biotech Medical Lab MA SR3 32,799.12 11,927.84
16 Bayshore Pharmacy VT SR3 6,010.36 44,140.87
17 Children Doctors Hospital RI SR3 15,890.00 34,210.56
18 St Anne's Hospital MA SR3 41,009.53 2,431.80
19 Landmark Medical Center CA SR3 22,630.79 29,000.00
20 Miriam Womens Hospital VT SR3 8,900.00 23,009.54
21 Ladys Clinic CA SR3 19,210.87 75,921.06
22 Kindheart Hospital MA SR3 21,007.45 56,750.00
23 Good Shepherd Med Laboratory RI SR2 538.62 3,279.89
24 St. Pauls Hospital NH SR2 1,067.45 10,452.56
25 Gregg's Pharmacy MA SR2 22,052.70 3,771.28
26 Angelic Hospital CA SR2 36,210.84 70,845.32
27 Mayor Clinic MN SR2 573.34 39,745.90
28 Bradley Hospital NH SR2 9,430.72 24,500.00
29 Infants Clinic CA SR2 23,431.08 78,091.29
30 Braintree Hospital MA SR2 36,609.80 48,208.00
31 VIP Hospital CA SR2 17,892.05 95,361.23
32 Miriam Hospital MA SR2 14,800.44 20,200.00
33 Lukes Medical Center VT SR2 15,067.54 32,340.32
34 GoodNews Medical Center RI SR2 11,400.51 43,250.00
35 Forgary Labs MA SR1 52,890.08 6,670.41
36 De Bellis Pharmacy RI SR1 12,715.35 35,300.00
37 Hospital for Children CA SR1 23,875.00 58,945.78
38 Woman & Infants RI SR1 7,915.99 59,600.24
39 Depasquale Pharmacy RI SR1 14,214.50 18,000.00
40 Goodkids Clinic CA SR1 27,800.00 23,784.90
41 Kent Hospital MA SR1 17,987.44 4,120.74
42 Butler Hospital RI SR1 11,215.67 45,000.00
43 Moms Clinic CA SR1 19,056.31 67,820.00
44 Foster Blood Tests MA SR1 32,594.27 4,275.56
45 Goodwill Hospital CA SR1 34,712.92 98,317.53
46 Childrens Hospital NH SR1 20,002.45 45,400.00
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started