Estimate a multiple linear regression

Assignment Help Econometrics
Reference no: EM132370611 , Length: word count : 1000

Research Report Group Assignment

This assignment uses data from the BUPA health insurance call centre. Each observation includes data from one call to the call centre. The variables describe several characteristics of the call (eg the length of the call, the amount of silence in the call), characteristics of the customer (eg state of residence, family type, number of adults and children), and measures of performance (eg net promoter score, sentiment score of the customer). In this assignment we are interested in predicting the net promoter score and the length of the call.

Please use the dataset CallCentre.dta and associated information file CC_DEFINITIONS_.XLSX to answer these questions. Use the software program STATA 15 available through RMIT MyDesktop for all data analysis.

1. Calculate descriptive statistics using the ‘summarize’ command for the variables net_promoter_score, total_silence,total_silence_weighted, agent_to_cust_index and agent_crosstalk_weighted and present the results in a table. Comment on what we learn about these variables from the descriptives. Graph a scatter plot of net_promoter_score  against agent_crosstalk_weightedand describe the relationship between these two variables.   

2. Estimate a multiple linear regression with net_promoter_score as the dependent variable and total_silence_weighted, agent_to_cust_indexand agent_crosstalk_weightedas the explanatory (independent) variables. Predict the change in net_promoter_score associated with a 0.1 increase in total_silence_weighted and a 0.01 increase inagent_crosstalk_weighted.Assuming this is the correct model specification, are we sure that total_silence_weighted has a negative effect? [Hint: consider the t-statistic and p-value]

3. Add dummy variables to the regression to control for all of the potential effects of State and Package. Make sure the base category is customers with the “HOSPITAL AND EXTRAS” package in NSW. Carefully interpret the estimated coefficient on the package1 dummy variable you have included. Why is this NOT a very important result?

Attachment:- Assignment Data Files.rar

Reference no: EM132370611

Questions Cloud

Incremental after-tax return on investment : If the firm maintains its receivables turnover of 10 times, how much will the receivables balance increase?
Determine future human resources needs : How would you collaborate with managers in other sections to determine future human resources needs?
Development of a personal business model : RMIT University - BUSM4496 Human Resource Management for Entrepreneurship and Innovation Assignment - Individual career modelling
Conduct and describe a list of demographic statistics : BME6576- Conduct and describe a list of demographic statistics on survey participants. Explore and interpret meaningful relationships among variables/groups.
Estimate a multiple linear regression : ECON1066-Basic Econometrics-RMIT-Australia-Estimate a multiple linear regression with net_promoter_score as the dependent variable.
Discuss your opinion on social media : Watch the Movie War Games from 1983. According to the New York Times, this movie had a tremendous effect on President Ronald Reagan. Discuss in 500 words.
What is the purpose of workplace policies : What is the purpose of workplace policies and procedures in an organisation?
Create an ipo chart for the given problem : Builders Inc. wants a program that allows its salesclerks to enter the diameter of a circle and the price of railing material per foot. The program should.
What are some barriers to good communication : What are some barriers to good communication?

Reviews

len2370611

9/13/2019 10:45:20 PM

Show your tables and calculations as well as answering the questions in full sentences. Please make sure your tables of results are neatly formatted, not just copied and pasted from STATA, and that you write your answers in clear sentences. You should write no more than 1000 words (not including tables/calculations) in total for this assignment. The number of words, tables, graphs, calculations given in parentheses after each question are a guide.

Write a Review

Econometrics Questions & Answers

  How can monetary policy maintain the economy

If policy succeeds in maintaining full employment, what happens to inflation?

  How many units would be consumed domestically

Suppose that in the domestic market for computer chips the demand is Pd = 110 Qd . The domestic supply is Ps = 10 + Qs . Foreign suppliers would be willing to supply any number of chips at a price of 30$.

  Measure the marginal utility per dollar

Let MUA = z = 10 ? x and MUB = z = 21 2y, where z is marginal utility per dollar measured in utils, x is the amount spent on product A, and y is the amount spent on product B. Assume that the consumer has $10 to spend on A and B-that is, x + y = 1..

  What are the firms profit-losses at the level of production

Vaguely remembering his intoductory economics course, thechief Financial officer tells the CEO it is better to produce 1case of ball bearings , because marginal revenue equals marginalcost at the quantity . what are the firms's profit /losses at t..

  State the effect on sample size of an increase

State the effect on sample size of an increase in each of the following factors, assuming all other factors are held constant:

  Compute method of moments and maximum likelihood estimators

Generate a random sample of N = 1, 000 for θ = 3, compute the method of moments and the maximum likelihood estimators. Compare them with the true population parameter.

  A monopsonic fast food chain exhibits a demand for labor

a monopsonic fast food chain exhibits a demand for labor given by w210-3l where w denotes the wage and l the quantity

  Determine fixed costs equal value of the last three digits

Given the above variable cost data and assuming fixed costs equal the value of the last three digits of your MDC student ID, create a file using Excel that lists Output, Fixed Cost, Variable Cost, Total Cost, Average Fixed Cost, Average Variable C..

  What is the real inflation tax paid by maria for second year

Assume that Maria Moneybags keeps $1000 in cash in her sock drawer. Over the first year, the inflation rate is 10%. What is the real inflation tax paid by Maria for this year. What is the real inflation tax paid by Maria for the second year

  Find the expected direct material cost and direct labor cost

A small company expects to produce 8,000 items in the upcoming year. The current material cost is $5.25 each. 14 minutes of direct labor are required per unit. Workers are paid $7.50 per hour. 2,133 direct labor hours are forecasted for the produc..

  Calculate the point price elasticities of supply

Consider the market for cigarettes in New York City and Los Angeles. Suppose the daily demand for cigarettes in NYC is given as Qd=1000-100P, and the demand in LA is Qd=900-200P. The market supply for the two markets is the same: Qs=100+200P.

  Find the firms profit maximizing price and quantity

The firm's production manager claims that the firm's average cost of production is minimized at an output of 40 units. Furthermore, she claims that 40 units is the firm's profit-maximizing level of output. Explain whether these claims are correct.

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