All our Essay orders are Original, and are written from scratch. Try us today at 30% off

Summarize the nation and the dependent variables that are possible outliers.

Want answers to the assignment Below?

Text or Whatsapp Olivia at +1 (307) 209-4351


 

WHY?

This question is often asked: “Why Excel and Word?” As I have stated in class before, individuals that will deal with data, whether analysts, accountants, product managers, etc…, need to be able to find patterns in the data and report on them. This is a brief introduction to that world. Given that this is an economics class, the project will focus on economic data.

It has been heavily studied that inflation-adjusted GDP (aka Real GDP) is affected by a myriad of variables, such as incomes, education rates, unemployment levels, and inflation. Multiple proxies and models have been put together to try and find better measurements of real GDP. Well, it is our turn. For this project, you will investigate which of the following variables has the greatest explanatory ability on real GDP: (1) employed individuals, (2) a human capital index (think of this as a proxy for training and education), and/or (3) the inflation of popular foods.

The data set is based on the 2019 real GDP levels for over 150 nations.

DIRECTIONS

You have until December 18, 2020 11:59:59pm PST to turn in an EXCEL/WORD document via Canvas. The subject header must be E3060 – PROJECT – LAST NAME, FIRST NAME. Any deviation from this will result in a 10 point penalty.

You will download the file called ECON3060PROJECT.XLS from the Class Project Module found on Canvas.

There are two sections (see QUESTIONS FOR THE PROJECT):

1. Data Exploration and Preliminary Analysis

2. Multiple Regression/Model Building

You will perform some analyses in Excel, save it and then provide a summary in Word. There is no required length. You are going to be graded on completing the EXCEL portion and the summarizing of the data in WORD/PDF document. I will not grade on grammar. You are encouraged to use the class notes for the exercise.

COMMON EXCEL FORMULA

=AVERAGE() =MEDIAN() =STDEV.S() – Std Dev for a sample

=STDEV.P() – Std Dev for a population =VAR.S() – variance for a sample

=VAR.P() – variance for a population

QUESTIONS FOR THE PROJECT

PART 1: Data Exploration and Preliminary Analysis

DUE DATE

QUESTIONS, PART I
Point Value

1
How many data points are there in each data set?
1

2
What is the average, median, variance and standard deviation of each variable?
7

3
Graph each variable using a bar chart
5

4
Are the data skewed?
1

Which direction?
1

Why? (Use a Z-score to prove your reasoning)
5

5
Summarize the nation and the dependent variables that are possible outliers.
5

TOTAL
25

PART 2: Multiple Regression

DUE DATE

QUESTIONS, PART II
Point Value

6
Create scatter plots between the dependent and each independent variable? Show the individual R2 value. What are the correlations? Which variable seems to be the strongest and weakest?
10

7
Determine the formula for this regression.
1

8
What is the coefficient of determination? What is the adjusted coefficient of determination? What does each mean?
3

9
At what point is each independent variable significant? What does a 1 unit increase in each independent variable do to the dependent variable?
4

10
What is the mean squared error for this model? What does it mean?
3

11
Test the overall significance of the model.
4

TOTAL
25

UPLOAD YOUR RAW DATA FILE AND A SUMMARY IN WORD/PDF FORMAT

The post Summarize the nation and the dependent variables that are possible outliers. first appeared on Assignment writing service.

  

Testimonials

Mh! not bad…

The worst part ever was to find my deadline postponed for 1 hour ! They couldn`t finish the essay within...

Best Service

The book review I asked for is so amazing! Endless thanks to your team for completing my review and for...

Great Job

Great job! Those were you, guys, who made my coursework perfect in time according to all my requirements. I will...

Comes through every time

I have used this website for many times, and each time they found perfect writers for me and they produce...

No Complaints So far Guys

Yeah …I really like all the discounts that they offer, the prices are very flexible. Plus they have different promotions...

Best

They look cool and trustworthy enough to me. I gather they made discounts as their prices are quite affordable if...

CLICK HERE  To order your paper

About Scholarfront Essay writing service

We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.

How It Works

To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.

Are there Discounts?

All new clients are eligible for upto 20% off in their first Order. Our payment method is safe and secure.

 CLICK HERE to Order Your Assignment

 

ORDER WITH 15% DISCOUNT

Let your paper be done by an expert

Custom Essay Writing Service

Our custom essay writing service has already gained a positive reputation in this business field. Understandably so, all custom papers produced by our academic writers are individually crafted from scratch and written according to all your instructions and requirements. We offer Havard, APA, MLA, or Chicago style papers in more than 70 disciplines. With our writing service, you can get quality custom essays, as well as a dissertation, a research paper, or term papers for an affordable price. Any paper will be written on time for a cheap price.

Professional Essay writing service

When professional help in completing any kind of homework is all you need, scholarfront.com is the right place to get it. We guarantee you help in all kinds of academia, including essay, coursework, research, or term paper help etc., it is no problem for us. With our cheap essay writing service, you can be sure to get credible academic aid for a reasonable price, as the name of our website suggests. For years, we have been providing online custom writing assistance to students from countries all over the world, including the United States, Canada, the United Kingdom, Australia, Italy, New Zealand, China, and Japan.