Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask Microeconomics Expert

Economics


Home >> Microeconomics

Problem 1:

1. Plot a scatter chart to examine the relationship between the Year Movie Released and Sales. Include a trend line for this scatter chart. What does the scatter chart indicate about Sales over time for all the movies?

2. Generate a frequency distribution, percent frequency distribution, and histogram for Sales, Use bin sizes of $100 million. Interpret the results. Do any data points appear to be outliers in this distribution?

3. Use the PivotTable to generate crosstabulation for movie type and rating. Determine which combination of type and rating are most represented in the top 50 movie data.

Problem 2:

I. Develop numerical summaries of the data (mean, median, standard deviation, range and the correlation for each pair of variables). Present your results in tabular form.

2. Develop an estimated simple linear regression model that can be used to predict the contributors giving rate, given the graduation rate. Is there a relationship between the two variables? Discuss your findings and explain how you reached your conclusions.

3. Develop an estimated multiple linear regression model that could be used to predict the contributors giving rate, using the graduation rate, percentage of classes offered with fewer than 40 students, and Student to teacher ratio as independent variables. Discuss your findings and explain how you reached your conclusions.

4. Based on the results in parts 2 and 3, do you believe another regression model may be more appropriate? Estimate this model and explain how you reached your conclusion.

5. Results suggest that the relationship between the contributors giving rate and the graduation rate may be nonlinear. Do you agree with this statement? Explain why? If you agree estimate and discuss the new nonlinear model.

6. What conclusions and recommendations can you derive from your analysis? Which schools are achieving a substantial higher contributors giving rate than would be expected? Which schools are achieving a substantial lower contributors giving rate than would be expected?

7. Do you think that other independent variables could be included in the model? Why? Give examples of such independent variables.

Attachment:- problem1.xlsx

Attachment:- problem2.xlsx

Microeconomics, Economics

  • Category:- Microeconomics
  • Reference No.:- M91265100
  • Price:- $70

Guranteed 36 Hours Delivery, In Price:- $70

Have any Question?


Related Questions in Microeconomics

Question the us economy slowed down sharply in the latter

Question: The US economy slowed down sharply in the latter half of 2000, and the actual recession started early in 2001. Monetary policy eased sharply throughout 2001, and for the first half of the year, fiscal policy di ...

Question analyze the economic effect on various industries

Question: Analyze the economic effect on various industries in the US as well as other countries if a Tariff (or tax) or 30% is imposed on imports from China (and China only) to the US. Please distinguish different indus ...

Question what is an organization at what three levels is

Question: What is an organization? At what three levels is organizational behavior usually examined? Select a restaurant, supermarket, church, or some other organization familiar to you. Discuss managerial functions and ...

Question imagine that a 10000 ten-year bond was issued at

Question: Imagine that a $10,000 ten-year bond was issued at an interest rate of 6%. You are thinking about buying this bond one year before the end of the ten years, but interest rates are now 9%. a. Given the change in ...

Question 1 explain the logic underlying the law of one

Question: 1. Explain the logic underlying the law of one price and the theory of purchasing power parity. 2. How will a decrease in the federal goverment's budget deficit affect the equilibrium interest rate in the bond ...

Question samsung runs a 5-year old semiconductor plant that

Question: Samsung runs a 5-year old semiconductor plant that makes 100,000,000 memory chips per year and cost $150,000,000 when it was built. Now they want to build a plant to make 250,000,000 memory chips per year. If t ...

Question to solve the congestion problems of the big cities

Question: To solve the congestion problems of the big cities, Congress decides to increase the Federal gasoline tax by 25 c per gallon, with a rebate to largely rural states; the net effect will raise approximately $20 b ...

Question what are the assumptions of the monopolistic

Question: What are the assumptions of the Monopolistic Competition Model? Even if there exist same number of consumers, same technology and cost curves and the same number of firms in the no-trade equilibrium both at HOM ...

Question a countrys economy is described in table 2 using

Question: A country's economy is described in Table 2. Using information in Table 2, answer questions (2.1), (2.2), (2.3) and (2.4) Phillips curve p -p-1=-0.55x( U-Un) Natural rate of unemployment uN = 5% Previous year's ...

Question in 2001 and 2002 political opinion was bitterly

Question: In 2001 and 2002, political opinion was bitterly divided between the Republicans, who wanted to cut high marginal personal income tax rates and offer retroactive benefits to corporations by canceling the altern ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As

Follow Us

© Copyright 2013-14 mywordsolution.com All rights reserved