6/17/26, 10:13 AM C268 Exam Questions & Answers | 100% Verified solutions (2026) UPDATE |2026!! STUDY GUIDE EXAM Flashcards | Quizlet
C268 Exam Questions & Answers | 100% Verified
solutions (2026) UPDATE |2026!! STUDY GUIDE
EXAM
Save Add to calendar
Terms in this set (38)
In the "Input Analysis" section of the =AVERAGE('Past Events'!C4:C103) for each column
spreadsheet model, calculate the
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.)
https://quizlet.com/1190112437/c268-exam-questions-answers-100-verified-solutions-2026-update-2026-study-guide-exam-flash-cards/?new 1/10
, 6/17/26, 10:13 AM C268 Exam Questions & Answers | 100% Verified solutions (2026) UPDATE |2026!! STUDY GUIDE EXAM Flashcards | Quizlet
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 are Food (highest correlation number)
most highly correlated with
attendance? Select the correct
answer from the drop-down list in
cell L32.
https://quizlet.com/1190112437/c268-exam-questions-answers-100-verified-solutions-2026-update-2026-study-guide-exam-flash-cards/?new 2/10
C268 Exam Questions & Answers | 100% Verified
solutions (2026) UPDATE |2026!! STUDY GUIDE
EXAM
Save Add to calendar
Terms in this set (38)
In the "Input Analysis" section of the =AVERAGE('Past Events'!C4:C103) for each column
spreadsheet model, calculate the
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.)
https://quizlet.com/1190112437/c268-exam-questions-answers-100-verified-solutions-2026-update-2026-study-guide-exam-flash-cards/?new 1/10
, 6/17/26, 10:13 AM C268 Exam Questions & Answers | 100% Verified solutions (2026) UPDATE |2026!! STUDY GUIDE EXAM Flashcards | Quizlet
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 are Food (highest correlation number)
most highly correlated with
attendance? Select the correct
answer from the drop-down list in
cell L32.
https://quizlet.com/1190112437/c268-exam-questions-answers-100-verified-solutions-2026-update-2026-study-guide-exam-flash-cards/?new 2/10
