pls help me
1. The data set provided in the Excel file (Chapter 5.1) is a sample from the data collected in March 2023 and describes the type of user-customer or subscriber in the Bluebikes system. Use this data set to answer the following questions: a) What is the size of the sample? What is the number of subscribers in the sample? What is the number of non-subscribed customers? b) Based on the numbers in part a, calculate the probability of selecting a subscriber if one user is randomly selected. P( subscriber) = ? c) Find the probability that among 40 randomly selected users exactly 32 are subscribers. d) Find the probability that among 40 randomly selected users at least 32 are subscribers. e) Find the mean and the standard deviation of this distribution (n=40). f) Is it unusual to have 36 subscribers in a sample of 40 students? g) 199003 users used the Bluebikes system in March 2023. The sample of the 100 data values that you used to answer the questions above is from the first 100 users listed in the data set of 199003 total users. What type of sample is this? What does it suggest about the validity of the results? Don't use the binomial probability formula! Use a calculator or software to solve the problem. Basic Editor for office files chrome extension Data file; Final Project_F23 (1).xIsx File Edit Insert Format Help fx Subscriber Chapter 51 Basic Editor for Office files chrome extension://bpr X Data file; Final Project_F23 (1).xlsx File Edt Insert Format Help fx Subscriber \begin{tabular}{|c|c|c|} \hline & A & 8 \\ \hline 29 & & Subscriver \\ \hline 30 & 29 & Subscriber \\ \hline 31 & 30 & Subscriber \\ \hline 32 & 31 & Customer \\ \hline 33 & 32 & Customer \\ \hline 34 & 33 & Subscriber \\ \hline 35 & 34 & Subscriber \\ \hline 36 & 35 & Subscriber \\ \hline 37 & 36 & Subscriber \\ \hline 38 & 37 & Subscriber \\ \hline 39 & 38 & Subscriber \\ \hline 40 & 39 & Subscriber \\ \hline 41 & 40 & Subscriber \\ \hline 42 & 41 & Subscriber \\ \hline 43 & 42 & Customer \\ \hline 44 & 43 & Subscriber \\ \hline 45 & 44 & subscriber \\ \hline 46 & 45 & Subscriber \\ \hline 47 & 46 & Subscriber \\ \hline 48 & 47 & Subscriber \\ \hline 49 & 48 & Subseriber \\ \hline so & 49 & Customer \\ \hline 51 & 50 & Subscriber \\ \hline 52 & 51 & customer \\ \hline 53 & 52 & Customer \\ \hline 54 & 53 & Subseriber \\ \hline 55 & 54 & Subscriber \\ \hline 56 & 55 & Customer \\ \hline 57 & 56 & Customer \\ \hline \end{tabular} C D E F G H A Chrome-extension://bprncpldpdma/fig X Data file; Final Project_F23 (1).XIsx File Edt Insert Format Help fx Subscriber \begin{tabular}{|c|c|c|} \hline & A & 8 \\ \hline 57 & 56 & Customer \\ \hline 58 & 57 & Subscriber \\ \hline 59 & 58 & Subscriber \\ \hline 60 & 59 & subscriber \\ \hline 61 & 60 & subscriber \\ \hline 62 & 61 & Customer \\ \hline 63 & 62 & Subscriber \\ \hline 64 & 63 & Subscriber \\ \hline 65 & 64 & subscriber \\ \hline 66 & 65 & subscriber \\ \hline 67 & 66 & Subscriber \\ \hline 68 & 67 & Subscriber \\ \hline 69 & 68 & Subscriber \\ \hline 70 & 69 & Subscriber \\ \hline 71 & 70 & Customer \\ \hline 72 & 71 & Subscriber \\ \hline 73 & 72 & Subscriber \\ \hline 74 & 73 & Customer \\ \hline 75 & 74 & Customer \\ \hline 76 & 75 & Subscribet \\ \hlinen & 76 & Customer \\ \hline 78 & 77 & subscriber \\ \hline 79 & 78 & Customer \\ \hline 80 & 78 & subscriber \\ \hline 81 & 80 & Subvcriber \\ \hline 82 & 81 & If Customer \\ \hline 83 & 82 & Subscriber \\ \hline 34 & 80 & Subscriber \\ \hline os & 84 & If subscriber \\ \hline \end{tabular} C D E F G H 1 J Calibin 11. H u A. 8
