You will submit your HW assignment within Canvas in the Assignments area. Remember to use naming convention detailed in the syllabus. Word, Excel, screenshots, .jpegs, .pdfs &/or all types of documents can be submitted.
Follow the instructions listed below regarding the expected HW deliverable.Submit homework by the due date and time.
The same
instructions apply for all homework problems. It is vitally
important that you do a good job defining the problem,
stating assumptions, explaining your analysis, feel free to use
graphs, tables, and/or any other means to get your point across.
Simply writing an answer down is
woefully inadequate (i.e., you will receive no points).
Remember: You are telling a "story" in the attempt to win a contract from a client, do your best to tell the story, win the contract, and get paid (or in this case get an excellent grade!)
Complete problems #4 & #5 from the spreadsheet textbook Chapter 3 with the following instructions:
For both problems complete parts
a & b, but DO NOT
complete part c for each problem.
For each problem, in place of part c, create a 95%
confidence interval for both sets of data. Use
the z-table &/or t-table from the textbook to find
the proper z &/or t values when constructing the
confidence intervals.
Create a short executive summary presenting the
details of each problem (i.e., descriptive statistics)
& the confidence intervals you created. Follow
these instructions for the executive summary:
Your work
should consist of:
a.
A cover sheet with your name and the date.
b.
A 1-PAGE Executive Summary of your work including
explanations, calculations, diagrams, etc. Please feel free to
include as much
detail as you think necessary but remember you have limited
space.
c.
Executive summaries are expected to be typewritten (i.e.,
MS-Word,
WordPerfect). However, calculations can be handwritten.
Clarity and neatness
are expected.
d.
Please refer to the website for further information
regarding writing
executive summaries. You may use any font and spacing
that is reasonable.
i.e., 0.25-inch margins and font size 10 are at the low end of
reasonable. At a
minimum your summary must have section headers & structure
(e.g.,
Introduction, Analysis, Recommendations).
Remember you are presenting this to your boss.
e. Please combine all
calculations, spreadsheets,
diagrams, graphs, etc., in a
section & label it Appendix A. If you are running short on
space in your executive
summary, you may reference pages in the Appendix. (This may
come in handy for
certain diagrams, graphs, etc.) It is vitally important that
you link your work
to the executive summary, i.e., I will NOT go searching
for answers, spell
them out in your executive summary and show your work in the
Appendix!!
You
will
be graded on both your calculations and your presentation.
Calculations will be
weighted approximately 75% and your presentation (i.e., the
executive summary)
will be weighted 25%. Just a reminder, if I can't read it or
find it, I can't
grade it.
A typical HW will have the following parts:
- a cover page with your name and date,
- your executive summary,
- an appendix cover page, and
- your appendix pages.
You may
turn in both a Word file and an Excel file (the Excel file
would
most likely contain your Appendix material).
NOTE: I WANT ONLY 1
(ONE) EXECUTIVE SUMMARY THAT
INCLUDES ALL HW PROBLEMS. DO NOT CREATE MORE THAN 1
(ONE) EXECUTIVE SUMMARY!!
PLEASE EMAIL ME IF THIS IS NOT CLEAR.