Question

In: Statistics and Probability

Part 1: Firm Performance In this spreadsheet, you will find data with a number of variables...

Part 1: Firm Performance

In this spreadsheet, you will find data with a number of variables that are commonly studied in business strategy research. Working from column A across, each firm has an identifier code. Firm ownership is a dummy coded variable where 0 = publicly-traded and 1 = privately-held firm ownership. Firm performance is the company’s self-assessment about the extent to which they meet/exceed performance expectations.

The remaining variables are factors that are predicted to influence performance. Customer orientation measures the extent to which a firm focuses on its customers and their needs, wants, and preferences. Long term orientation, benchmarking, and planning are variables that speak to the firm’s strategic planning capacity. Finally, risk taking is the firm’s capacity for risky strategic moves. Each variable is measured by managers reporting on a 1-7 Likert scale.

Firm ID

ownership (private = 1)

firm performance

customer orientation

long-term orientation

benchmarking

planning

risk taking

Risk taking squared

firm performance

1

1

4.33

5.50

6.20

5.00

1.00

5.00

25.00

4.33

2

0

4.00

6.25

4.80

1.83

4.17

5.80

33.64

4.00

3

0

4.67

6.25

2.00

5.50

5.33

4.80

23.04

4.67

4

0

4.00

4.25

3.80

1.67

5.00

6.00

36.00

4.00

5

1

4.67

6.25

5.60

4.50

4.50

5.20

27.04

4.67

6

1

5.67

5.25

4.20

5.00

2.17

3.00

9.00

5.67

7

0

2.67

3.00

5.40

5.33

5.50

4.60

21.16

2.67

8

0

2.67

5.75

3.00

4.33

4.67

6.80

46.24

2.67

9

1

5.00

6.25

5.00

3.33

3.83

4.80

23.04

5.00

10

1

6.00

6.25

5.80

3.83

4.33

2.80

7.84

6.00

11

1

5.00

6.00

3.80

4.00

3.00

3.60

12.96

5.00

12

0

5.00

6.25

5.00

4.67

3.83

4.20

17.64

5.00

13

1

5.33

5.50

5.40

2.67

4.00

3.20

10.24

5.33

14

0

5.00

4.75

5.20

6.67

6.00

1.60

2.56

5.00

15

0

4.67

6.50

6.80

4.67

5.50

4.00

16.00

4.67

9. Estimate a multiple regression model for the influence of customer orientation, long-term orientation, and benchmarking on firm performance. Report the regression equation and interpret your findings.

Please answer with Excel solved with toolpak if necessary.

Solutions

Expert Solution

Using Excel with toolpak.

Steps:

Data-->Data Analysis--->Regression:

Select data:

Input data--firm performance

Output data-- Influence of customer orientation, long-term orientation, and benchmarking.

Output Result:

R-squared value is 0.2834 or 28.34% that is low it's mean our model not good for predictions.

Regression Equation:

firm performance = 0.8923 + 0.4805 * (customer orientation) + 0.1592 *(long-term orientation) + 0.0548 *(benchmarking)

Interpretation of Regression Coefficient:

If customer orientation is increase by 1 unit then firm performance will increase by 0.4805.

if long term orientation is increase by 1 unit then firm performance will increase by 0.1592.

if benchmarking is increase by 1 unit then firm performance will increase by 0.0548.

all coefficient of p value is greater than 0.05 it is mean they are not significant for firm performance.


Related Solutions

1. Find the real part, the imaginary part, and the modulus of the complex number 1...
1. Find the real part, the imaginary part, and the modulus of the complex number 1 + 8i 2 + 3i , showing your work. 2. Find all three solutions of the equation 2z 3 + 4z 2 −z −5 = 0. (Hint: First try a few “simple” values of z.) You must show all working.
Part 2: Problem Solving - Journal Using the data in the Option 1 Spreadsheet (linked at...
Part 2: Problem Solving - Journal Using the data in the Option 1 Spreadsheet (linked at the bottom of the page), perform the accounting required for the acquisition of Little, Inc. by Big, Inc. Within the worksheet, you are to: Select an accounting method (either cost or equity) and explain why you selected this method Perform the required journal entries Complete the consolidation worksheet Prepare the consolidated balance sheet in good form Complete all work on the spreadsheet attached to...
"Measuring Firm performance." Then, each of you pick a firm, and do out the following: Find...
"Measuring Firm performance." Then, each of you pick a firm, and do out the following: Find and report its current P/E ratio. Calculate and report on any two of its ratios: its ROE, CR, D/E ratio or TAT for two years. Ideally use 2016 and 2017, and if 2017 numbers are unavailable, use 2015 and 2016. Write a brief (100 word) paragraph comparing its performance over the two years:2016 and 2017 (or 2015 and 2016). Everyone please use a different...
On the next page, you will find sample performance appraisal data for 10 employees at a...
On the next page, you will find sample performance appraisal data for 10 employees at a bank. A rating of 1 is considered poor, 3 is satisfactory, and 5 is excellent. Due to budget constraints, we want to train any employee whose performance is less than satisfactory. Look at the data and determine: a) What types of training are needed for all employees? _____________________________________________________________________________________________ _____________________________________________________________________________________________ _____________________________________________________________________________________________ _____________________________________________________________________________________________ _____________________________________________________________________________________________ b) What training is needed by each employee? Dawson ____________________________________________________________________ Coombs ____________________________________________________________________...
"In Excel, if you had a spreadsheet containing four variables (date, product_type, quantity, and unit_price) and...
"In Excel, if you had a spreadsheet containing four variables (date, product_type, quantity, and unit_price) and your boss asked you to calculate the total revenue generated by Product A between Thanksgiving and New Years, what formula would you use?" COUNT(() COUNTIFS() SUMIF() SUMIFS() Question 2 "In regression, what is the best description of a residual?" Select the correct answer The square of actual values. The predicted values. Error. The sum of the squared difference between the predicted and actual values....
Part (1) Consider the data in the above table for number of pets in 100 households....
Part (1) Consider the data in the above table for number of pets in 100 households. Do the following: 1 Number of Pets 0 1 2 3 4+ Count 19 26 29 13 13 – Use the R command chisq.test to test whether the data can be fitted by a Poisson model with α = 0.05. Report the p-value and the number of degrees of freedom from your test. – Are there any corrections necessary and if so why? –...
A telemarketing firm is monitoring the performance of its employees based on the number of sales...
A telemarketing firm is monitoring the performance of its employees based on the number of sales per hour. One employee had the following sales for the last 19 hours 9,5,2,6,5,6,4,4,4,7,4,4,7,8,4,4,5,5,4 What is the mode, median and mean for the distribution of number of sales per hour? What is the first and third quartile for the distribution of number of sales per hour? For the distribution of sales per hour, what is the interquartile range? Draw a dot plot for the...
1. You have a number of variables -- a response variable and some proposed predictors. A...
1. You have a number of variables -- a response variable and some proposed predictors. A correlation matrix may help to give an idea of the strength of the linear relationships present. For the purposes of regression analysis, what would be desirable in terms of … a) …the observed correlation between each proposed predictor and the response variable? (2) b) …the observed correlations among the predictors themselves? (2) 2. Explain the fact that, over the course of a year, the...
In Appendix B you will find performance data for four mutual funds. Rank the funds according...
In Appendix B you will find performance data for four mutual funds. Rank the funds according to performance. Detail any concerns you have about the rankings. If you had to choose one of the funds to invest in, which would it be and why? Appendix B: Fund Performance Metrics Manager: ArrowMark Conestoga Elk Creek Stephens Assets Under Management (AUM) ($M) $1,237 $1,851 $1,235 $1,861 # Securities 110 48 98 109 Alpha 4.06 2.08 -1.44 -2.82 Beta 0.95 0.85 1.04 0.84...
Part 2 Please open “PERFORMANCE” data. Data is about a survey result of manager who is...
Part 2 Please open “PERFORMANCE” data. Data is about a survey result of manager who is planning to make a research on influence of competence and motivation on employees’ performance. However; he suspects whether there is a multicollinearity or not in his regression model he is planning to construct and he requested your help. Please support him with implementing multi collinearity analysis and report your findings. Your report must contain scatter plot matrix, correlation matrix, and a regression output including...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT