Week 1 Written - Excel - Analytics

Week 1 Written Assignment - Using Data Sets - Analytics

For some of this week's individual written assignment, you will use the attached supplied data sets from the online learning center for this textbook. There is no need to type the data. 

Data Sets

Exercises from Lind book:

1-20

2-14

2-20

2-42

Excel must be used for this and for all subsequent written assignments. Submitted assignments using Word or other applications will not be accepted.

Reference:

Title: Statistical Techniques in Business & Economics

Author: Douglas A. Lind, William G., Marchal, Samuel A. Wathen

Publisher: McGraw-Hill Education

Edition/Year: 16th edition/2014

ISBN-13: 978-0-07-802052-0

Optional but recommended

Title: Basic Statistics Using Excel 2010

Author: Ronald Merchant

Publisher: McGraw-Hill Irwin

Edition/Year: 15th Edition/2012

ISBN-13: 978-0-07-754103-3

Please look under data sets or data files depending on the type of problem.

For data sets, please go to:

http://highered.mheducation.com/sites/0078020522/student_view0/data_sets.html

please notice that the Goodyear data set is the one that contains the Real Estate data

For data files, please go to:

http://highered.mheducation.com/sites/0078020522/student_view0/data_files.html

In case that different versions of the same file are available please always use the first one in the list.

Here you have some suggestions for your written homework:

You need to  answer questions typing text in an Excel file . You can type your answer in one cell and you can adjust the size of the cell to any length you need and you can format the cell to contain multiple lines. You can also insert a text box and type any amount of text on it as you would do in a Word processor. 

- "Lind book" refers to your textbook "Statistical Business in Economics" by Lind, Marchal and Wathen. The exercises are labeled using the Chapter number followed by the problem number, for example problem 1-20 refers to Chapter 1 problem 20, and so on (you can find this particular problem at page 16 in your textbook). 

- Please don't submit multiple Excel files or zip files for one homework. Instead, you can submit one Excel file with multiple worksheets using descriptive labels at the tabs. Please don't submit Word files or any other format unless you really need to do it, in that case please check with me first. Include a Cover page and Reference page as the front (Sheet 1) and the Reference (The last Sheet).

- Organize all your work in an orderly sequence indicating clearly your answers, procedures and conclusions. Address every question in the same sequence that they were asked indicating clearly which part of the question you are answering (a, b, c, etc.)

-If applicable use formulas to perform computations instead of just typing numeric results. Typing formulas in Excel would allow me to check your work in greater detail and would be able to track any errors. 

- One of the most important part in responding a numeric question is your conclusion. Correct numeric results are usually not enough (unless you are only asked for a numeric result), in many cases I need to know what is your interpretation of your results.  Specially when we study inferential statistics you need to state clearly what are your conclusions, first in technical terms, and then followed by a plain English interpretation.