Homework3

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.

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!)

Sharp Flashing Text

TAKE NOTICE OF NEXT PARAGRAPH BELOW

NOTE: THE PROBLEMS I AM ASKING YOU TO COMPLETE ARE IN CHAPTER 3 OF THE eBOOK NOT THE CHAPTER 3 APPENDIX. THE TWO PROBLEMS LISTED BELOW CAN BE FOUND ON PAGE 178 THAT IS PRINTED LITERALLY ON THE eBOOK IN THE TOP LEFT OF THE PAGE. ANALOGOUSLY AS YOU SCROLL THROUGH THE .PDF FILE ONLINE WITHIN THE eBOOK'S WEBSITE IT MAY SAY PAGE 54/94 ON THE COUNTER AT THE TOP OF THE .PDF SCROLLING PAGE.

PLEASE EMAIL OR CALL IS YOU DO NOT UNDERSTAND THIS OR NEED ASSISTANCE

Complete problems #4 & #5 from the spreadsheet textbook Chapter 3 (again NOT the Chapter 3 Appendix) 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.

In addition, for #4 the following statement is made: a colleague states that she believes if the sample variance of the speeds on H1 was to quadruple (4x original) then the confidence interval would at least double in size. Show your work & process & explain if this is a true statement.

In addition, for #5 the following statement is made: the same colleague states that she believes if the confidence level was increased to 99% that the width of the C.I. would increase by about 0.5 earned runs per nine innings pitched. Show your work & process & explain if this is a true statement.

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.