C268 Exam Questions & Answers | 100% Verified
solutions (2026) UPDATE |2026!! STUDY GUIDE
EXAM
Save
Terms in this set (38)
In the "Input Analysis" section of the =AVERAGE('Past Events'!C4:C103) for each
spreadsheet model, calculate the column
average attendance and sales for
each type of product from the past
events listed in the "Past Events"
worksheet.
In the "Input Analysis" section of the =STDEV.S('Past Events'!C4:C103) for each column
spreadsheet model, calculate the
sample standard deviation for
attendance and sales for each type
of product from the past events
listed on the "Past Events"
worksheet. (Note for Excel 2007
users: Excel 2007 does not support
a specific function to calculate
sample standard deviations. Use the
STDEV function instead.)
, In the "Input Analysis" section of the =CONFIDENCE.NORM(0.05,J7,$I$3)
spreadsheet model, calculate the
95% confidence interval for the
sales for each type of product. (You
will not calculate a confidence
interval for attendance.) Use the
number of events (calculated in cell
I3) as part of your calculations.
(Note to Excel 2007 users: the
CONFIDENCE.NORM function is
not supported in Excel 2007. Use
the CONFIDENCE function
instead.)
In the "Input Analysis" section of the =CORREL('Past Events'!$C$4:$C$103,'Past
spreadsheet model, calculate the Events'!D4:D103)
correlations between the sales of
each type of product and event
attendance. Use appropriate
ranges from the "Past Event"
worksheet for your calculations.
The sales for which product type Food (highest correlation number)
are most highly correlated with
attendance? Select the correct
answer from the drop-down list in
cell L32.
solutions (2026) UPDATE |2026!! STUDY GUIDE
EXAM
Save
Terms in this set (38)
In the "Input Analysis" section of the =AVERAGE('Past Events'!C4:C103) for each
spreadsheet model, calculate the column
average attendance and sales for
each type of product from the past
events listed in the "Past Events"
worksheet.
In the "Input Analysis" section of the =STDEV.S('Past Events'!C4:C103) for each column
spreadsheet model, calculate the
sample standard deviation for
attendance and sales for each type
of product from the past events
listed on the "Past Events"
worksheet. (Note for Excel 2007
users: Excel 2007 does not support
a specific function to calculate
sample standard deviations. Use the
STDEV function instead.)
, In the "Input Analysis" section of the =CONFIDENCE.NORM(0.05,J7,$I$3)
spreadsheet model, calculate the
95% confidence interval for the
sales for each type of product. (You
will not calculate a confidence
interval for attendance.) Use the
number of events (calculated in cell
I3) as part of your calculations.
(Note to Excel 2007 users: the
CONFIDENCE.NORM function is
not supported in Excel 2007. Use
the CONFIDENCE function
instead.)
In the "Input Analysis" section of the =CORREL('Past Events'!$C$4:$C$103,'Past
spreadsheet model, calculate the Events'!D4:D103)
correlations between the sales of
each type of product and event
attendance. Use appropriate
ranges from the "Past Event"
worksheet for your calculations.
The sales for which product type Food (highest correlation number)
are most highly correlated with
attendance? Select the correct
answer from the drop-down list in
cell L32.
