Conduct a multiple regression analysis

Assignment Help Microeconomics
Reference no: EM132298059 , Length: word count:3000

Economic Principles and Decision Making

Assessment: Report

Learning Outcomes

1. Interpret and successfully apply economic concepts of supply and demand for effective organisational problem solving.
2. Apply quantitative methods to forecast complex business variables including demand, supply, production and costs.
3. Critically analyse production processes and cost functions and classify the main forms of market structures as well as recommend appropriate pricing and strategies.
4. Critically evaluate the role and impact of various forms of government intervention in the economy including the implications of competition and deregulation policy for managerial practices.

Instructions:

Schmeckt Gut plans the market launch for the Schmeckt Besser energy bar in Atollia within the next couple of months. The Research Department of Schmeckt Gut has conducted a market analysis of Atollia. The results are provided for you in the supplied EXCEL file.

Based on international sources, the Research Department is comfortable in working with the following scenarios on the future development of average income in Atollia, the inflation rate development and tariff rates on imports from Industria:

- Income growth: 1% increase or 3% increase or 5% increase or 7% increase
- Inflation rate development: 2% increase or 3% increase or 4% increase or 5% increase
- Tariffs on imports from Industria: 7.5% or 10% or 5% or free trade

Note: These developments are not necessarily matched to each other in the sequence shown above; meaning that we do not know if the 1% increase in income is associated with a 2% increase in inflation rate and a 7.5% tariff rate.

Your task:

Your task is to write a 3,000-word report addressed to the Board of Directors of Schmeckt Gut in which you address the following:

- Do you think you can match the different projections? That is, do you think that a 5% increase in income is associated with a 10% tariff rate and a 2% inflation rate? Explain by linking your discussion to the following concepts:
o supply and demand
o aggregated demand and aggregated supply
o the Philipps Curve, and
o the Laffer curve.
- What impact would the different predictions of income development, inflation rate development and tariff rate development have on the potential demand of Schmeckt Gut? Conduct a multiple regression analysis using data in the supplied Excel file and then interpret the results. Fully discuss and explain their implications.
- Make recommendations as to what the Board of Directors should do under each of your scenarios, based on your matching of the predictions.


The precise format of the report will be informed by research undertaken by the student using the Torrens University library. Formal document sections such as executive summary, table of contents and appendices are not counted in the word count. Assume that the prescribed word limit is literally a limit and that the board will reject any report that breaches it.

Final report clarifications
1. If the government in Atollia wants reduce consumption of imported products they may increase tariffs. In this question you are required to test what will happen if, say for example, 5% increase in income is associated with 2% inflation rate, etc.
2. You need to predict how changes in average in income, tariffs, and inflation would impact on the average demand. In this case, you need to run regressions once again.

For example, Income 3%, 5% or 7%. If you multiply the income column with these percentage you will get the values for all 3 scenarios.

Tariffs 7.5% , 10% , 5% or free trade. Same as above

Inflation is a Nominal Income (indicated as "average income") minus inflation. That can also be incorporated. Example: income of 15000 - 3% inflation Conducting a multiple linear regression (in log linear form) which is Log Y = α + β1X1 +β2X2 +β3X3 + β4X4. The log is in base e so you need to put in Excel the formula = LN (average demand). In case, you want to know more about how to do it in excel, do go youtube with these keywords or see the links below.

That should be interpreted as the impact of these variables (variable 1, etc) on the demand. Say, with + sign increase, with - sign (increase in tariff, which is actually tax, and its impact on demand).

Another hint: according to Laffer Curve as taxes (tariffs in our case) increase from low levels, tax revenue collected by the government also increases. It also shows that tax rates increasing after a certain point would cause people not to work as hard or not at all, thereby reducing tax revenue and as a result their real income.

Or:
According to Phillips; Decreased unemployment in an economy correlates with higher rates of inflation (up to a certain extent). That does not necessarily translates into greater total real income in the economy but we could assume that more people will be employed affecting sales dependant on the number of stores (this is just an assumption).

Attachment:- Economic Principles and Decision Making.rar

Reference no: EM132298059

Questions Cloud

Discuss one key take-away : Discuss one key take-away that you learned from the industry presentations and panel.
What are the differences between intrusion detection systems : What are the differences between intrusion detection systems (IDS) and intrusion prevention systems (IPS)?
Which would you recommend to a client : How do they differ in term of strength and operation? Which of this did you prefer and why? Which would you recommend to a client?
What is the significance of including aup in a security : Acceptable Use Policy - AUP is a very prominent component in a Security Policy.
Conduct a multiple regression analysis : ECON6000 - Economic Principles and Decision Making - Laureate International Universities - Conduct a multiple regression analysis using data in the supplied
Evaluate output from an accounting information system : ACC5000 Accounting Applications - University of Southern Queensland - Critically evaluate output from an accounting information system
Mitigate the issue or decrease the potential threat : What actions the company should take to mitigate the issue or decrease the potential threat
Show that p is closed under union : 1) Show that P is closed under union, concatenation, and complement.
Define a transaction with respect to database systems : 1. Define a transaction with respect to database systems. 2. Define the transaction properties outlined by the acronym ACID.

Reviews

len2298059

5/2/2019 4:59:27 AM

Specific position (perspective or argument) is presented expertly, authoritatively and imaginatively, accurately taking into account the complexities of the issue(s) and scope of the assignment. Limits of position are acknowledged. Justifies any conclusions reached with sophisticated arguments. Highly sophisticated and creative analysis, synthesis of new with existing knowledge. Strong application by way of pretested models and / or independently developed models. Recommendations are clearly justified based on the analysis/synthesis. Consistently demonstrates a systematic and critical understanding of context and purpose of the assignment.

len2298059

5/2/2019 4:59:10 AM

High Distinction 86-100 (Exceptional) Evidence of an exceptional level of achievement of learning objectives across the entire content of the course demonstrated in such areas as interpretation and critical analysis, logical argument, creativity, originality, use of methodology and communication skills. A sophisticated understanding of the field or discipline/s. Systematically and critically discriminates between assertion of personal opinion and information substantiated by robust evidence from the research/course materials and extended reading. Mastery of concepts and application to new situations/further learning.

Write a Review

Microeconomics Questions & Answers

  The free rider problem

Question: Explain why the free rider problem makes it difficult for perfectly competitive markets to provide the Pareto efficient level of a public good.

  Failure of the super committee is good thing for economy

Some commentators have argued that the failure of the “Super committee” is good thing for the economy?  Do you agree?

  Case study analysis about optimum resource allocation

Case study analysis about optimum resource allocation: -  Why might you suspect (even without evidence) that the economy might not be able to produce all the schools and clinics the Ministers want? What constraints are there on an economy's productio..

  Fixed cost and vairiable cost

Questions:  :   Which of the following are likely to be fixed costs and which variable costs for a chocolate factory over the course of a month?  Explain your choice.

  Problem - total cost, average cost, marginal cost

Problem - Total Cost, Average Cost, Marginal Cost: -  Complete the following table of costs for a firm.  (Note: enter the figures in the  MC   column  between  outputs of  0 and 1, 1 and 2, 2 and 3, etc.)

  Oligopoly and demand curve problem

Problem based on Oligopoly and demand curve,  Draw and explain the demand curve facing each firm, and given this demand curve, does this mean that firms in the jeans industry do or do not compete against one another?

  Impact of external costs on resource allocation

Explain the impact of external costs and external benefits on resource allocation;  Why are public goods not produced in sufficient quantities by private markets?  Which of the following are examples of public goods (or services)? Delete the incorrec..

  Shifts in demand and movements along the demand curve

Describe the differences between shifts in demand and movements along the demand curve. What are the main factors which can shift the demand curve? Explain why they cause the demand curve to shift. Use examples and draw graphs to support your discuss..

  Article review question

Article Review Question: Read the following excerpts from the article "Fruit, veg costs surge' by Todd, Dagwell, published in the Herald on January 25th 2011 and answer questions below:

  Long-term growth, international trade & globalization

Long-term Growth, International Trade & Globalization:- This question deals with concepts such as long-term growth, international trade and globalization. Questions related to trade deficit, trade surplus, gains from trade, an international trade sce..

  European monetary union (emu) in crisis

"Does the economic bailout of Spain and Greece spell the beginning of the end for the European Monetary Union (EMU)?"

  Development game “settlers of catan”

Read the rules of the game, the overview and the almanac for the Development Game "Settlers of Catan"

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!

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