Robert Meyers
Problem Set 2 [Primarily Classes 4-5]: Working With and Visualizing Data
Due Fri.Sept.q23,6pm/Mon.Sept.26 9:30am in Room 520F
HAND IN AND POST COMPLETED EXCEL FILE ON QUESTROM TOOLS ASSIGNMENTS
PROBLEM SET 2. KEEP YOUR EXCEL FILE FOR THE NEX

SM222 Modeling Business Decisions
Summer 2016
Problem Set 3 - Answers
Question 1
The Massachusetts Department of Education administers a mandatory test for all MA public schools
called the MCAS. A statistician was asked to evaluate how average teacher sal

QM222 Modeling Business Decisions
Summer 2016
Problem Set 2 - Answers
Due Wednesday, June 8th by 6pm
Part 1: Short answer questions.
a. The vast majority of hotel guests do not take the time to rate their hotel experience on
Tripadvisor.com. What sort of

QM222 Problem Sets for Fall 2016
Contents
Problem Set 1 [Classes 1-3]: Describing Data, Statistical Inference.2
Problem Set 2 [Primarily Classes 4-5]: Working With and Visualizing Data.6
Problem Set 3 [Primarily Classes 6-8]: Correlation, the Right Statis

QM222 Modeling Business Decisions
Summer 2016
Problem Set 4 - Answers
Due Tuesday June 28 by 6pm
I.
Multiple Slopes
Executives at an on-line clothing company named Impress is interested in knowing
whether it would make more sales if it offered free shippi

I :5- Relationships\
Author Table the Wrote Table Book Table Publisher Table
il Author Number 5? Book Code il Book Code 5? Publisher Code
Author Name V Author Number Boork Title Publisher Name
Sequence Number Publisher Code Publisher City
Book Type
Book

Exhibits
Exhibit 1: Basic statistics of annual income by gender
Gender
Female
$81,841
$70,000
$3,128,965,765
$55,937
$7,000
$577,000
$50,000
$97,000
Mean
Median
Variance
Standard deviation
Minimum
Maximum
25th Percentile
75th Percentile
Male
$117,523
$95,

QM222 Modeling Business Decisions
Summer 2016
1
2
Average of 04 Employment at
Graduation
Grand
Total
3
1/2
3/5
3/4
3/5
d) Create a scatter plot with GMAT Score on the horizontal axis and average salary on the
vertical axis. Describe below any relationship

Handout 9. Standard Errors on Coefficients: What Affects Happiness?
The General Social Survey is an annual survey of Americans. We are using data from the 2012
survey wave. GSS respondents rate their happiness from 1 to 7, with 7 being completely happy.
I

Data from student survey (Ward 1990)
[see Hamiltons Statistics with Stata 5 for more detail]
drink
gpa
Ranges from 1 to 33. Higher levels mean more drinking.
Ranges from 0 to 4.
SUMMARY OUTPUT
Regression Statistics
Multiple R 0.298317
R Square 0.088993
Ad

QM222 Modeling Business Decisions
Spring 2017
BOSTON UNIVERSITY SCHOOL OF MANAGEMENT
QM222: Modeling Business Decisions
Spring 2017 D1 and H1 Section
Professor Karpovsky
Email: [email protected]
Office: 551
Office Hours: Friday 1:30-2:30 pm (or by appointme

QM222 Modeling Business Decisions
Spring 2017
QM222 Problem Set #3
Due Friday, Mar. 3rd by 6pm in Room 520F
Brookline Housing Data
1. Use the PS3+Brookline+condos.xlsx dataset in QuestromTools. Run three different regressions to
predict price. Write the r

QM222 Modeling Business Decisions
Spring 2017
Problem Set 4
Due Friday March 31st by 6pm in Room 520F
1. Read carefully the New York Times article titled Revisiting the Value of Elite Colleges,
describing an application of multiple regression.
a. What is

QM222 Modeling Business Decisions
Spring 2017
QM222 Problem Set #1
Due Friday, February 3rd by 6pm in Room 520F
Note: You need to show your work to get credit
1
Do Elite MBAs earn more?
For this question, use the data file Pset1_2_USNewsRanking.xls found

QM222 Modeling Business Decisions
Spring 2017
Problem Set 5
Due Friday April 7th by 6pm in Room 520F
1. You work for the Federal Aviation Administration in the Planning Department and are in
charge of modelling the number of passengers in international fl

QM222 Modeling Business Decisions
Spring 2017
Problem Set 2
Due Friday, Feb. 17th by 6pm in Room 520F
Part 1: Short answer questions.
a
The vast majority of hotel guests do not take the time to rate their hotel experience on
Tripadvisor.com. What sort of

QM222 Modeling Business Decisions
Spring 2017
Problem Set 2
Due Friday, Feb. 17th by 6pm in Room 520F
Part 1: Short answer questions.
a
The vast majority of hotel guests do not take the time to rate their hotel experience on
Tripadvisor.com. What sort of

Handout 10. Simple Regression Case: London Olympics
Each team should hand in the answers to this case, on the extra team copy that we hand out
in class.
You have been hired by the Chinese Olympic Committee as a statistical advisor to their coaches.
Your f

QM222 Modeling Business Decisions
Spring 2017
QM222 Problem Set #3
Due Friday, Mar. 3rd by 6pm in Room 520F
Brookline Housing Data
1. Use the Pset3_brookline_codes.xls dataset in QuestromTools. Run three different regressions to
predict price. Write the r

MBA Programs sheet gives data from US News Ranking of MBA programs
GMAT SAT sheet gives the predicted average SAT score of students for each possible GMAT score (based on self-reporte
MAT score (based on self-reported data from a sample of Chicago Booth s

CycleShare Case
This file contains data on the profitability of a competitor's locations
Variables in Data Table1:
locationid
locationType
bikescore
profit (in $1000s)
An id number for a location
= A for Apartment, =U for university
Bike score for this lo

QM222 Final Exam Review Notes
Class 15
Simple Regression
Y b b X e
0
1
Multiple Regression
Y b b X b X b X . b X e
0
1 1
2
2
3
3
k
k
Why use Multiple Regressions?
2 Reasons:
o To get closer to the correct/causal (unbiased) coefficient
By controlling for

Observation: one instance of the thing you are examining; a person, a day, a state, a store, a row; n is # of observations
Variable: one characteristic or property of an observation; income (person),# visitors to web(day); avg edu level (store); column; v

Problem Sets for Fall 2015
Contents
Problem Set 1
[Classes 1-3]: Forming Questions, Statistical Inference.2
Problem Set 2
[Primarily Classes 4-5]: Working With and Visualizing Data.6
Problem Set 3
[Primarily Classes 6-9]: Correlation, Regression, Choosing

Madison Palms Section C1
Problem Set 3 [Primarily Classes 6-9]: Correlation,
Regression, Choosing the Right Statistic
Due by 6 pm Monday October 5 in Room 520F
I.
Thought Questions
1. The vast majority of hotel guests do not take the time to rate their ho

Madison Palms
Professor Kahn
QM222- Section C1
29 September 2015
Project Part A: Wage Setting and Discrimination
Introduction
Even today, disparity in gender wages is a serious problem that exists in companies
nationally despite The Equal Pay Act that was

MBA Programs sheet gives data from US News Ranking of MBA programs
GMAT SAT sheet gives the predicted average SAT score of students for each possible GMAT score (based on self-reporte
MAT score (based on self-reported data from a sample of Chicago Booth s

Handout 8. Introduction to Regression
You now have an extra tool (regression!) to help your producer make decisions about what type
of movie to produce. Again use the dataset Handout 6+8 Movie Data subset.xlsx posted on
QUESTROM Tools ResourcesData sets.

Handout 6. Relationships Between Variables
Part 1: What Kinds of Films Earn the Most Money?
Do this part as a TEAM. Use the dataset Handout 6+8 Movie Data subset posted on
QUESTROM Tools ResourcesDatasets. You are a consultant for a Hollywood film studio.

Handout 11. Multiple Regression
Part 1: Buying a condo
Which of these models would you use to assess the financial profitability of replacing a
spare room with a second full bathroom in a condo in Beacon Street? How much are you
willing to pay for the con

Handout 13. Forecasting, Goodness of fit, and Non-linear Terms
Work on this case as a team.
You work for Apple, in the division responsible for selling TV content through the iTunes store.
Apple advertises on Googles website to encourage people searching

Handout 12. Multiple Dummy Categories
MARCH MADNESS!
Some people claim that the No. 5 seed teams in the NCAA tournament are jinxed. Look at the
graph below to see why! This graphs the average win precentage over this period for this seed.
(Dont know what

Handout 14. Omitted Variable Bias
Part 1: Revisiting the value of elite colleges
The New York Times article titled Revisiting the Value of Elite Colleges, describes an
application of multiple regression. You read this article for Problem Set 5.
Assume tha