User Account

All Pages

help, Microeconomics

Assignment Help:
1. Select a data series that you wish to forecast. Make sure that it has some importance to you relative to business, future occupation or other special interest. Obtain monthly or quarterly time series data from one of the data sources listed in either of these websites: www.rfe.org, www.economagic.com or other approved sources shown in “Data Sources” under Chapter 1 of the Course Home. Note, do not select seasonally adjusted data.
2. You need at least 80 observations. You may have more if you wish. You can refer to the project outline for additional details. Download and save the data as an EXCEL file. EXCEL files can be easily imported or copied into Minitab. The first column should be the date and the second column should be you data. Always label the columns appropriately and include (Y) as part of your data label. Create a citation for the data series including the exact webpage or document page that contained the data.
3. Go back to the same data source or other approved data source. This time you will need to obtain time series data for a minimum of three related “explanatory” variables. We will call these related variables the independent (X) variables. These variables will be monthly or quarterly with dates consistent with your (Y) variable downloaded previously. If your (Y) variable is monthly, your (X) variables must also be monthly. If your (Y) variable is quarterly, your (X) variables will also need to be quarterly. All variables should be from the same time period. You can refer to the project outline for further details. Note, do not select seasonally adjusted data. You want the data for each variable to be unadjusted for seasonality.
(See the note below relative that data that should not be used in the project.)
4. Download and save all your (X) variables as an excel file. Label each column of variable data accordingly. Recall that the first column is the dates and the second column is the selected (Y) variable. The third column will be (X1), the forth column will be (X2) and the fifth column will be (X3) and so forth for additional variables. Be sure to include a name of data in each column label in addition to the appropriate (X) notation. Please ensure that the data observation dates are in sync with the appropriate dates in the first column (C1). Make sure that each Y and X data series has a separate citation. This can be placed after the EXCEL data columns.
5. Copy and paste your dates (C1), (Y) variables (C2) and X variables (C3 to C5, etc.) into the MINTAB worksheet section. Copy your labels as well so that I can understand which variables you are analyzing. Save the EXCEL worksheet with your project name followed by data. It must be included as the last page of the proposal.
6. Run basic (descriptive) statistics from Minitab on each variable beginning with Y. Comment on the mean value, data range and the standard deviation. Is the variation about the mean relatively large or close to the mean value? Remember that large standard deviations about the mean may indicate forecasting difficulty.
7. Run individual “Time Series Plots” on each Y and X variables. Comment on what you see in the time series plot (positive or negative trend, periodic business cycles (lasting more than one year), seasonality (cycle lasting exactly one year). Comment on the X variables similarity or difference from the observations of the Y data.
8. Run “Scatter Plots” of (Y) against each (X) variable separately. Use Minitab and enter the Y variable first then the X variables in turn. Comment on the linear (or lack of linear) nature of each YX variable relationships. The relationships may be strongly (positive or negatively linear), moderately related, weakly related or not linearly related. With three X variables you should have three scatter plots to discuss.
9. Get the “Correlation Matrix” (you can find it under Stat/Basic Statistics/Correlation in Minitab) of (Y) and each of the explanatory (X) variables. You need to tell me which (X) variables are linearly related to (Y) and which (X) variables are not. Also note the correlations between the X variables. They should not have stronger correlations than each X variable correlation to Y. If the XX correlations are stronger you may wish to replace the X variable with the weakest correlation to Y with another. Complete any variable replacements before you submit the proposal.
10. The proposal should include (A) your statement of the forecasting problem. Give a good reason for choosing the Y variable ---“It is important to me because…”. Follow that with (B) statements regarding why you chose each of the independent variables (X) for your analysis. This will be your hypotheses relative to the explanation of why Y changes. Follow that with the analysis of the data in the points 6 and 7 above. Then provide further support of your hypothesis with scatter plots and correlation coefficient findings of each X variable’s relationship to the (Y) variable in points 8 and 9 above.
11. Remember that the proposal should be a formal word document and include the relevant MINITAB output copied and pasted in word as well as the description and source of each variable. Minitab worksheet elements and Minitab graphs can be copied and pasted into the proposal as required. Again make sure to include all of the data and website or document that your data came from as your source.
12. Use 12 point New Times Roman type style double spaced for the proposal. You do not need a cover page for your proposal. Include a title in upper case centered type, the class and section number, the date and your name in upper/lower case centered at the top of the first page. Number your pages and be sure that you have run spell check on the entire document. Any subheadings should be centered upper/lower case type. Most proposals are no longer than 5 pages including 2 pages for the data. Do not include any forecast in the proposal. The proposal essentially sets up the forecast problem that you will address in this course.
This document should be uploaded to me at our designated eCollege Dropbox for the project proposals by midnight 2/08/2013
What to avoid is selecting Y and X variables.
1. Do not use seasonally adjusted data.
2. Make sure there are no missing data values.
3. Use either monthly or quarterly time series data.
4. You must have at least 80 observations of each variable.
5. Do not use Macro variables such as Money Supply, GDP, GNP, CPI, PPI, U.S. Interest Rates, U.S. Unemployment or Employment, U.S. Population for a Y variable. They may be used as X variables, however.
6. Do not select known components of the Y variable as X variables. (E.g. using male unemployment and female unemployment as X variables to forecast total unemployment.)
7. Try to use X variables that have logical connection to Y. The X variable should be useful in explaining variation in the forecast Y variable.
8. Try to use X variables that have a reasonable linear relationship with Y. That is the scatter plots indicate a linear relationship and the XY correlations are .30 or better.
9. If the XX correlations are greater than XY correlations drop the lowest correlated X variable and replace it with another variable that 1) has a significant correlation with Y and has a lower correlation with the other X variables.

Related Discussions:- help

Economic value to customer, Economic Value to Customer Economic V...

Economic Value to Customer Economic Value to Customer = EVC x = [LifeCycle costs of a competitor's product in relation to a home firm] - [Start-up Costs for the home fir

Growth of regional financial institutions, GROWTH OF REGIONAL FINANCIAL INS...

GROWTH OF REGIONAL FINANCIAL INSTITUTIONS: We find many levels of groupings of nations in the international arena. Groups of countries that share borders often have semi-perma

Average product of a factor - short period analysis, Average Product (AP) o...

Average Product (AP) of a Factor: The productivity of a factor is often seen in terms of its average contribution. Although not very important in the theoretical discussions,

Derivation of compensated demand curve, Derivation of compensated demand cu...

Derivation of compensated demand curve:  Hicksian compensated demand function for x 1 is given by x 1 =x 1 (p 1 , p 2 , U), where Hicksian compensated demand curve for a good

Fundamental economy problem., how a capitalist system solves the three fund...

how a capitalist system solves the three fundamental economic problems

Price limit thory, sylos labini model of limit price

sylos labini model of limit price

Determine the value of the marginal product of labor, Determine the value o...

Determine the value of the marginal product of labor. Equilibrium in the Labor Market Each firm will hire labor up to the point at that the value of the marginal product of

Demand schedule and demand curves, what is the combined total demand schedu...

what is the combined total demand schedule for Delgian cocoa beans that European and USA consumers buy

Benefits of education, Normal 0 false false false EN-IN...

Normal 0 false false false EN-IN X-NONE X-NONE MicrosoftInternetExplorer4

What do you mean by costs, Q. What do you mean by Costs? Costs Section ...

Q. What do you mean by Costs? Costs Section 56 of the Environment Act describes costs as including ‘costs to any person and costs to the environment'. The costs of a project a

Write Your Message!

Captcha
Order Assignment

Featured Services

Order Now

Popular Subjects

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +91-977-207-8620

Phone: +91-977-207-8620

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd