## Excel Add-In for Mac Users

If you are using a Mac and having trouble installing the Add-In for Exercise 2, try this link. Please post a comment if you are a Mac user and this is helpful. Thanks!

Category: Teaching

If you are using a Mac and having trouble installing the Add-In for Exercise 2, try this link. Please post a comment if you are a Mac user and this is helpful. Thanks!

**Due Thursday, September 5th**

Textbook Reading: **Chapter 2, pages 31-43**

Blog Reading: Geospatial Visualization in Business

Exercise #2 is described below. **This exercise is due before class on Thu, Sep 5th.** In-class time will be allocated, time permitting, to begin the assignment on Tue, Sep 3rd.

*Please prepare your answers to the exercise questions using Microsoft Word or the equivalent and submit via email to [email protected] with the Word (.doc or .docx) file or a PDF version attached.*

Apparently people are emailing lots of different document formats to Becky, making grading cumbersome. So, instead of emailing, **please print your Excercise and turn it in at the beginning of class on Thursday** (9/5). Sorry for any confusion.

- Complete Problem 2.1 on p. 22
- Complete Problems 2.7 and 2.9 on p. 28-29
- Install the “Analysis TookPak” – see p 49 for instructions
- Use the Excel database (downloaded last week: black_7e_excel_database) to complete Analyzing the Database problems 1, 2 and 3 on p. 47-48.

**Help for problem 2.1.** I entered the data in Excel, created bins and made histograms. Hopefully this will help you understand the problem. You can use this data and the histograms for parts a and b. But, part c is up to you. Which is more useful – 5 or 10 bins? Why? Link to Excel file: Ex2_2-1

- 8 years ago
- busad265
- Uncategorized
- Justin

Please share this survey with everyone you know who lives in Pueblo County and ask them to complete the survey to help us explore some statistical concepts.

**Due Tuesday, September 3rd**

Textbook Reading: **Chapter 2, pages 18-30**

Optional video:

Your first exercise is described below. **This exercise is due before class on Tues, Sep 3rd.** In-class time will be allocated, time permitting, to begin the assignment on Thu, Aug 29.

*Please prepare your answers to the exercise questions using Microsoft Word or the equivalent and submit via email to [email protected] with the Word (.doc or .docx) file or a PDF version attached.*

- Complete all Supplementary Problems 1.1-1.9 on pages 13-14.
- Download the nine databases in Excel format by clicking here: black_7e_excel_database
- Use the Excel database to complete Assignment questions 1-3 on page 16.

If you have trouble answering the questions you might want to read the Case Study about DiGiorno Pizza and the Case Solution. Here’s a link to download the Case Solution: ch01-CaseSolutions. Note that this Case Study is not required material for this exercise; I mention it and include the solutions here simply as a an example that you may find useful for completing the exercise.

For class on Thursday, August 29th

I will present these **PowerPoint slides** covering key material in Chapter 1. Click here to download the slides: ch01** [I may a few edits that can be found here: ch01-jh]**

Here’s a link to a **YouTube video** (6 min) that we will watch in class. The woman narrating the video is from New Zealand so she may be difficult for some to understand. But, hopefully it will be helpful to hear about the same topic presented another way.

There were a couple of helpful questions and answers on the YouTube page

Q1. But what is the difference between interval and ratio data or scale?? In my book they are given separately and i m not able to comprehend the difference between the two 🙁

A1. The difference isn’t usually relevant in statistics, so I didn’t confuse things by adding that level. Ratio data has a meaningful zero value, and ratios of numbers make sense. For example temperature is interval data as the difference between 30 degrees and 40 degrees is the same as the difference between 40 degrees and 50 degrees. However it is not meaningful to say that 40 degrees is twice as hot as 20 degrees. So temperature is not ratio data. Length in mm, is ratio data. 20mm is twice 10mm.

Q2. So basically it’s like this. Nominal data is numbers given to stuff like name Kevin=1 Women=2 but it does not imply order (such as I’m above women). Ordinal data does imply order but the intervals (amount) between the order may not be equal. Interval/Ratio/Scale data is quantitative of the data and gives mean, median, and standard deviation. Correct?

A2. Yup – you got it. Nominal doesn’t always have numbers assigned. It is often left as text.

**Due Thursday, August 29th**

Textbook Reading: **Chapter 1, pages 1-16**

Optional video (registration on the publisher website is required): http://www.wiley.com/college/black/0470931469/kbvidtutorials/Black_7e_Video_Ch01/simulations/videos/asset.index.htm

Please follow this link and complete the survey: https://www.surveymonkey.com/s/HTTCXWV

Also, answer this quick poll:

[polldaddy poll=7349250]

Welcome to Inferential Statistics and Problem Solving! I’ve attached the course syllabus here: BUSAD 265 Fall 2013 Holman