Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Data Analysis Assignment # 1 QBA 2 1 1 Quantitative Analysis For the first Data Analysis Assignment I would like to you to do 3

Data Analysis Assignment #1
QBA 211 Quantitative Analysis
For the first Data Analysis Assignment I would like to you to do 3 things: 1) Choose the topic of your dataset 2) describe the format that you envision for the data and 3) describe the source of the data.
Choosing the topic of your dataset is pretty easy. However, you have many options to choose from here. It could be sports related (e.g. major league baseball player statistics like batting average, salary, strike outs, etc.) It could be economic data (e.g. unemployment rate, GDP, GNP, etc.) It could be real estate values from Yuma or another area (e.g. asking price of a property/ square footage, acreage of the lot, etc.) The most important factor is to pick a topic that is interesting to you. That will make the data analysis exercises that you will perform on this dataset more meaningful and valuable to you.
The next thing you must do is to describe the format of your dataset. As an example of the format that your dataset should have please see the file Movies2016.xlsx in the Chapter 2 folder of Excel data files for this class (located in the content folder). Note that each row in the dataset contains information about one movie's performance. Each column contains the data for one variable. The variable name is located the top of the column. For example, Opening gross Sales, Weeks in Release, etc. The data under the variable name in the column are the data values for the dataset.
You will be making the same decisions about your dataset: What is my item of interest that will be represented in a row of my dataset? This might seem obvious and maybe it is. But, for the economic dataset example that I gave above, you could choose to do it at least two different ways. You could have each row be a different country at a certain point in time or you could choose to have each row be a different point in time (quarter, year, etc.) for the same country (e.g USA). So, it might not be as obvious as you think.
In Chapter 1 you read about different types of variables: categorical variables and numerical variables. Numerical variables are further broken down into discrete and continuous variables. For definitions of each of these variable types please see pp.5-8 in the textbook. Your dataset should contain a mixture of different variable types so that you can complete the different data analysis assiznments over the semester. Specifically, it should contain at least 4 categorical
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions