Excel Assignment 2

(I). The data project should be based on a dataset which you select, probably downloaded from some public web source, and which I suggest ought to have at least n=50 observations, a continuous response variable Y, and at least several other meaningful continuous or categorical explanatory X-columns. Ideally, since you will be looking for relationships between the X and Y columns, the source and subject matter of the data should relate to a topic about which you have some general knowledge to aid you in asking and answering meaningful research questions relevant to the data.

(II). The objective of your data project should be to discover and present a regression-type statistical model you can in EXCEL to explain the Y responses in your dataset in terms of the X explanatory variables. A successful project will relate the research questions to a regression-type model, use techniques developed in the QMBS 3360 course to build the best such model you can for the data

(III). It is not required that your data analysis project be “completed/finished” in the sense of necessarily reaching firm conclusions about a realistic problem, but you should make some effort to showcase tools learned in the course; not all tools should be there, but at lease few things you comfortable with. Demonstrate that you have uncovered the regression-model structure of the data that was possible with a reasonable amount of effort.

 

(IV). Do not hand in raw data or any computations or pictures you do not explicitly refer to in accompanying text. You must briefly explain the research problem, methodology and solution in words, with reference to pictures and numerical exhibits. Hand in no less than 6 pages in a reasonable sized font and spacing.  Joint Probability Tables (

Examples to use:

Joint Probability Tables

Confidence Interval for Mean

Hypothesis test for proportion

Hypothesis Test for the Difference of Two Means

Confidence Interval for Difference of Means

Scatter Diagram, Regression Equation, and Residual Analysis

Scatter Diagram, Regression Equation, and Prediction

Confidence Intervals for Variance and Standard Deviation

*Please send me a project Proposal by 11.59PM April 9th. Just tell me what will be your data set and what you are going to do in 3-4 or more sentences.

**Final Draft Due date: May 09, 2021 by 11.59PM.

*** As I told you earlier, I am not going to make groups. However, you want you can find another 2 class mates and do a group project with 3 max per team. You can also do it by yourself without making groups. In that way you will learn a lot since you will do everything by yourself.