Data Analysis with Excel: Formula Assignment and Probability

This assignment focuses on creating and applying Excel formulas for data analysis and probability calculations. The task involves designing formulas to calculate probabilities related to active units, utilizing the PROB function. The solution demonstrates the application of formulas across a range of active units, extending beyond the initial specified range to accommodate a larger number of active units. The assignment emphasizes the practical use of Excel for statistical analysis, providing a hands-on approach to understanding and solving probability problems within a data-driven context. The student has provided the solution for this practical assignment. This solution is available on Desklib, a platform for students to access study materials and tools.

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)
=PROB(F3:F14,G2:V2,24,100) =PROB(G3:G14,H2:W2,24,100) =PROB(H3:H14,I2:X2,24,100)

Assignment on excel formula 3
=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)
=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 =PROB(M13:M24,N12:AC12,24,10 =PROB(N13:N24,O12:AD12,24,10

Assignment on excel formula 4
0) 0) 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
)