Data Science Assignment: Excel Formulas for Probability Calculations

This assignment presents an Excel-based solution for calculating probabilities using the PROB function. The task involves designing formulas to analyze the probability of a certain number of active units, ranging from 2 to 24, and extending to higher numbers like 100. The solution demonstrates the application of Excel formulas in probability calculations, providing a practical example of data analysis. The student has provided formulas to calculate the probability of common units (P(0)) based on the number of active units. The solution is designed to handle various scenarios, making it a comprehensive approach to the problem. This showcases the ability to use Excel as a tool for data science applications. The assignment also includes formulas such as =A2+2, which are used to generate data for the probability calculations.

Running head: Assignment on excel formula
Name of Institution:
Name of Student:
Professor:
Course:
Task: Assignment on excel formula
Date:

Assignment on excel formula 1

Assignment on excel formula 2
=2 =PROB(A2:A13,B1:Q1,24,100) =PROB(B2:B13,C1:R1,24,100)
=A2+2 =PROB(A3:A14,B2:Q2,24,100) =PROB(B3:B14,C2:R2,24,100)
=A3+2 =PROB(A4:A15,B3:Q3,24,100) =PROB(B4:B15,C3:R3,24,100)
=A4+2 =PROB(A5:A16,B4:Q4,24,100) =PROB(B5:B16,C4:R4,24,100)
=A5+2 =PROB(A6:A17,B5:Q5,24,100) =PROB(B6:B17,C5:R5,24,100)
=A6+2 =PROB(A7:A18,B6:Q6,24,100) =PROB(B7:B18,C6:R6,24,100)
=A7+2 =PROB(A8:A19,B7:Q7,24,100) =PROB(B8:B19,C7:R7,24,100)
=A8+2 =PROB(A9:A20,B8:Q8,24,100) =PROB(B9:B20,C8:R8,24,100)
=A9+2 =PROB(A10:A21,B9:Q9,24,100) =PROB(B10:B21,C9:R9,24,100)
=A10+2 =PROB(A11:A22,B10:Q10,24,100) =PROB(B11:B22,C10:R10,24,100)
=A11+2 =PROB(A12:A23,B11:Q11,24,100) =PROB(B12:B23,C11:R11,24,100)
=A12+2 =PROB(A13:A24,B12:Q12,24,100) =PROB(B13:B24,C12:R12,24,100)
=C1+1 =D1+1 =E1+1
=PROB(C2:C13,D1:S1,24,100) =PROB(D2:D13,E1:T1,24,100) =PROB(E2:E13,F1:U1,24,100)
=PROB(C3:C14,D2:S2,24,100) =PROB(D3:D14,E2:T2,24,100) =PROB(E3:E14,F2:U2,24,100)
=PROB(C4:C15,D3:S3,24,100) =PROB(D4:D15,E3:T3,24,100) =PROB(E4:E15,F3:U3,24,100)
=PROB(C5:C16,D4:S4,24,100) =PROB(D5:D16,E4:T4,24,100) =PROB(E5:E16,F4:U4,24,100)
=PROB(C6:C17,D5:S5,24,100) =PROB(D6:D17,E5:T5,24,100) =PROB(E6:E17,F5:U5,24,100)
=PROB(C7:C18,D6:S6,24,100) =PROB(D7:D18,E6:T6,24,100) =PROB(E7:E18,F6:U6,24,100)
=PROB(C8:C19,D7:S7,24,100) =PROB(D8:D19,E7:T7,24,100) =PROB(E8:E19,F7:U7,24,100)
=PROB(C9:C20,D8:S8,24,100) =PROB(D9:D20,E8:T8,24,100) =PROB(E9:E20,F8:U8,24,100)
=PROB(C10:C21,D9:S9,24,100) =PROB(D10:D21,E9:T9,24,100) =PROB(E10:E21,F9:U9,24,100)
=PROB(C11:C22,D10:S10,24,100) =PROB(D11:D22,E10:T10,24,100) =PROB(E11:E22,F10:U10,24,100)
=PROB(C12:C23,D11:S11,24,100) =PROB(D12:D23,E11:T11,24,100) =PROB(E12:E23,F11:U11,24,100)
=PROB(C13:C24,D12:S12,24,100) =PROB(D13:D24,E12:T12,24,100) =PROB(E13:E24,F12:U12,24,100)
=F1+1 =G1+1 =H1+1
=PROB(F2:F13,G1:V1,24,100) =PROB(G2:G13,H1:W1,24,100) =PROB(H2:H13,I1:X1,24,100)

Assignment on excel formula 3
=PROB(F3:F14,G2:V2,24,100) =PROB(G3:G14,H2:W2,24,100) =PROB(H3:H14,I2:X2,24,100)
=PROB(F4:F15,G3:V3,24,100) =PROB(G4:G15,H3:W3,24,100) =PROB(H4:H15,I3:X3,24,100)
=PROB(F5:F16,G4:V4,24,100) =PROB(G5:G16,H4:W4,24,100) =PROB(H5:H16,I4:X4,24,100)
=PROB(F6:F17,G5:V5,24,100) =PROB(G6:G17,H5:W5,24,100) =PROB(H6:H17,I5:X5,24,100)
=PROB(F7:F18,G6:V6,24,100) =PROB(G7:G18,H6:W6,24,100) =PROB(H7:H18,I6:X6,24,100)
=PROB(F8:F19,G7:V7,24,100) =PROB(G8:G19,H7:W7,24,100) =PROB(H8:H19,I7:X7,24,100)
=PROB(F9:F20,G8:V8,24,100) =PROB(G9:G20,H8:W8,24,100) =PROB(H9:H20,I8:X8,24,100)
=PROB(F10:F21,G9:V9,24,100) =PROB(G10:G21,H9:W9,24,100) =PROB(H10:H21,I9:X9,24,100)
=PROB(F11:F22,G10:V10,24,100) =PROB(G11:G22,H10:W10,24,100
)
=PROB(H11:H22,I10:X10,24,100)
=PROB(F12:F23,G11:V11,24,100) =PROB(G12:G23,H11:W11,24,100
)
=PROB(H12:H23,I11:X11,24,100)
=PROB(F13:F24,G12:V12,24,100) =PROB(G13:G24,H12:W12,24,100
)
=PROB(H13:H24,I12:X12,24,100)
=I1+1 =J1+1 =K1+1
=PROB(I2:I13,J1:Y1,24,100) =PROB(J2:J13,K1:Z1,24,100) =PROB(K2:K13,L1:AA1,24,100)
=PROB(I3:I14,J2:Y2,24,100) =PROB(J3:J14,K2:Z2,24,100) =PROB(K3:K14,L2:AA2,24,100)
=PROB(I4:I15,J3:Y3,24,100) =PROB(J4:J15,K3:Z3,24,100) =PROB(K4:K15,L3:AA3,24,100)
=PROB(I5:I16,J4:Y4,24,100) =PROB(J5:J16,K4:Z4,24,100) =PROB(K5:K16,L4:AA4,24,100)
=PROB(I6:I17,J5:Y5,24,100) =PROB(J6:J17,K5:Z5,24,100) =PROB(K6:K17,L5:AA5,24,100)
=PROB(I7:I18,J6:Y6,24,100) =PROB(J7:J18,K6:Z6,24,100) =PROB(K7:K18,L6:AA6,24,100)
=PROB(I8:I19,J7:Y7,24,100) =PROB(J8:J19,K7:Z7,24,100) =PROB(K8:K19,L7:AA7,24,100)
=PROB(I9:I20,J8:Y8,24,100) =PROB(J9:J20,K8:Z8,24,100) =PROB(K9:K20,L8:AA8,24,100)
=PROB(I10:I21,J9:Y9,24,100) =PROB(J10:J21,K9:Z9,24,100) =PROB(K10:K21,L9:AA9,24,100)
=PROB(I11:I22,J10:Y10,24,100) =PROB(J11:J22,K10:Z10,24,100) =PROB(K11:K22,L10:AA10,24,10
0)
=PROB(I12:I23,J11:Y11,24,100) =PROB(J12:J23,K11:Z11,24,100) =PROB(K12:K23,L11:AA11,24,10
0)
=PROB(I13:I24,J12:Y12,24,100) =PROB(J13:J24,K12:Z12,24,100) =PROB(K13:K24,L12:AA12,24,10
0)
=L1+1 =M1+1 =N1+1
=PROB(L2:L13,M1:AB1,24,100) =PROB(M2:M13,N1:AC1,24,100) =PROB(N2:N13,O1:AD1,24,100)
=PROB(L3:L14,M2:AB2,24,100) =PROB(M3:M14,N2:AC2,24,100) =PROB(N3:N14,O2:AD2,24,100)
=PROB(L4:L15,M3:AB3,24,100) =PROB(M4:M15,N3:AC3,24,100) =PROB(N4:N15,O3:AD3,24,100)
=PROB(L5:L16,M4:AB4,24,100) =PROB(M5:M16,N4:AC4,24,100) =PROB(N5:N16,O4:AD4,24,100)
=PROB(L6:L17,M5:AB5,24,100) =PROB(M6:M17,N5:AC5,24,100) =PROB(N6:N17,O5:AD5,24,100)
=PROB(L7:L18,M6:AB6,24,100) =PROB(M7:M18,N6:AC6,24,100) =PROB(N7:N18,O6:AD6,24,100)
=PROB(L8:L19,M7:AB7,24,100) =PROB(M8:M19,N7:AC7,24,100) =PROB(N8:N19,O7:AD7,24,100)
=PROB(L9:L20,M8:AB8,24,100) =PROB(M9:M20,N8:AC8,24,100) =PROB(N9:N20,O8:AD8,24,100)
=PROB(L10:L21,M9:AB9,24,100) =PROB(M10:M21,N9:AC9,24,100) =PROB(N10:N21,O9:AD9,24,100)
=PROB(L11:L22,M10:AB10,24,10
0)
=PROB(M11:M22,N10:AC10,24,10
0)
=PROB(N11:N22,O10:AD10,24,10
0)

Assignment on excel formula 4
=PROB(L12:L23,M11:AB11,24,10
0)
=PROB(M12:M23,N11:AC11,24,10
0)
=PROB(N12:N23,O11:AD11,24,10
0)
=PROB(L13:L24,M12:AB12,24,10
0)
=PROB(M13:M24,N12:AC12,24,10
0)
=PROB(N13:N24,O12:AD12,24,10
0)
=O1+1 =P1+1
=PROB(O2:O13,P1:AE1,24,100) =PROB(P2:P13,Q1:AF1,24,100)
=PROB(O3:O14,P2:AE2,24,100) =PROB(P3:P14,Q2:AF2,24,100)
=PROB(O4:O15,P3:AE3,24,100) =PROB(P4:P15,Q3:AF3,24,100)
=PROB(O5:O16,P4:AE4,24,100) =PROB(P5:P16,Q4:AF4,24,100)
=PROB(O6:O17,P5:AE5,24,100) =PROB(P6:P17,Q5:AF5,24,100)
=PROB(O7:O18,P6:AE6,24,100) =PROB(P7:P18,Q6:AF6,24,100)
=PROB(O8:O19,P7:AE7,24,100) =PROB(P8:P19,Q7:AF7,24,100)
=PROB(O9:O20,P8:AE8,24,100) =PROB(P9:P20,Q8:AF8,24,100)
=PROB(O10:O21,P9:AE9,24,100) =PROB(P10:P21,Q9:AF9,24,100)
=PROB(O11:O22,P10:AE10,24,100
)
=PROB(P11:P22,Q10:AF10,24,100
)
=PROB(O12:O23,P11:AE11,24,100
)
=PROB(P12:P23,Q11:AF11,24,100
)
=PROB(O13:O24,P12:AE12,24,100
)
=PROB(P13:P24,Q12:AF12,24,100
)