WGU C268 Spreadsheets- Event Profit 100% Pass
#1 =AVERAGE('Past Events'!C4:C103) ✔✔=AVERAGE('Past Events'!C4:C103)
#2 =STDEV('Past Events'!C4:C103) ✔✔=STDEV('Past Events'!C4:C103)
#3 =CONFIDENCE(0.95,J7,I13) ✔✔=CONFIDENCE(0.95,J7,I13)
#4 =CORREL('Past Events'!D4:D103,'Past Events'!C4:C103) ✔✔=CORREL('Past Events'!D4:D103,'Past Events'!C4:C103)
#6=FORECAST(I13,'Past Events'!D4:D103,'Past Events'!C4:C103) ✔✔=FORECAST(I13,'Past Events'!D4:D103,'Past Events'!C4:C103)
#11 =C15*C4 ✔✔=C15*C4
#12 =C15-C16 ✔✔=C15-C16
- / 1