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 ____________________________________________________________________...
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...
11. You are given the information of firm A and B for their performance evaluation. Firm...
11. You are given the information of firm A and B for their performance evaluation. Firm                              A                B                Sales                            60               55               EAT                               20               18               Total Assets                   75               72               Stockholder’s Equity       40               40               Suppose the industry average of net profit margin ratio, total asset turnover and equity multiplier is around 30%, 0.78 times and 1.9 respectively. Which firm appears to have problems?        Firm A has problems.        Firm B has problems.        None of them presents problems.        Both of them...
PLEASE PROVIDE A SPREADSHEET FOR EACH PART FOR PERSONAL REFERENCE Part 1: Using Excel’s Randbetween(0,9) function,...
PLEASE PROVIDE A SPREADSHEET FOR EACH PART FOR PERSONAL REFERENCE Part 1: Using Excel’s Randbetween(0,9) function, generate 200 samples of five random numbers between 0 and 9, calculate the mean of each sample. Show me the list of the 200 means. Typically, they should look like: 4.8, 3.6, 4.4, 6.0, etc. Part 2: Using Excel, calculate the overall mean of the 200 sample means (the average of the averages). This should be around 4.5. Part 3:   Using Excel, calculate the...
1. First you need to find the number of valence electrons in CH3Cl.
1. First you need to find the number of valence electrons in CH3Cl. For counting purposes with Lewis structures, the number of valence electrons in an atom of a main group element is equal to the last digit in the group number of that element in the Periodic Table. C is in Group ____________ H is in Group ____________ Cl is in Group ____________ In NH2Cl there is a total of ____________ valence electrons.2. The model consists of balls and...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT