advertisement

Nemsys LLC - Multiple Regression

100 %
0 %
advertisement
Information about Nemsys LLC - Multiple Regression
Business & Mgmt

Published on December 7, 2008

Author: CPappasOnline

Source: slideshare.net

advertisement

A regression analysis by: Christopher Pappas Gregory Davis Malcolm Campbell Iris Hu Amanda Zabriski

Predict the monthly engineer hours required to service a prospective client Better objectify certain cost factors Utilize results to assist NEMSYS in increasing efficiency and/or effectiveness

Predict the monthly engineer hours required to service a prospective client

Better objectify certain cost factors

Utilize results to assist NEMSYS in increasing efficiency and/or effectiveness

Every business today needs computer technology Impractical for every company to hire the proper employees needed to maintain working technology Service companies such as NEMSYS provide a cost-effective and efficient way to keep technology in working order

Every business today needs computer technology

Impractical for every company to hire the proper employees needed to maintain working technology

Service companies such as NEMSYS provide a cost-effective and efficient way to keep technology in working order

Interviewed executives at NEMSYS to understand the main drivers of engineer hours Collected NEMSYS client data Breakdown of monthly service hours for past 2 years Collected predictor data Performed regression analysis

Interviewed executives at NEMSYS to understand the main drivers of engineer hours

Collected NEMSYS client data

Breakdown of monthly service hours for past 2 years

Collected predictor data

Performed regression analysis

The regression equation is: AMH = 27.0 - 14.1 S + 0.492 WS + 0.69 NP + 5.53 AS - 13.0 NC + 0.201 NP 2 AMH = avg monthly engineer hours S = # of servers WS = # of workstations NP = # of network printer AS = avg savvy NC = avg network complexity NP 2 = network printer squared

The regression equation is: AMH = 27.0 - 14.1 S + 0.492 WS + 0.69 NP + 5.53 AS - 13.0 NC + 0.201 NP 2

AMH = avg monthly engineer hours

S = # of servers

WS = # of workstations

NP = # of network printer

AS = avg savvy

NC = avg network complexity

NP 2 = network printer squared

Lawfirm Average age of workstations Ratio of laptops to overall workstations

Lawfirm

Average age of workstations

Ratio of laptops to overall workstations

 

Analysis: Predictor Coef SE Coef T P Constant 26.96 13.25 2.04 0.076 S -14.092 6.361 -2.22 0.058 WS 0.4918 0.1158 4.25 0.003 NP 0.687 3.276 0.21 0.839 AS 5.527 4.353 1.27 0.240 NC -13.041 6.586 -1.98 0.083 NP^2 0.2012 0.4468 0.45 0.664  S = 6.35500 R-Sq = 81.5% R-Sq(adj) = 67.6%   Analysis of Variance Source DF SS MS F P Regression 6 1423.56 237.26 5.87 0.013 Residual Error 8 323.09 40.39 Total 14 1746.65

Analysis:

Predictor Coef SE Coef T P

Constant 26.96 13.25 2.04 0.076

S -14.092 6.361 -2.22 0.058

WS 0.4918 0.1158 4.25 0.003

NP 0.687 3.276 0.21 0.839

AS 5.527 4.353 1.27 0.240

NC -13.041 6.586 -1.98 0.083

NP^2 0.2012 0.4468 0.45 0.664 

S = 6.35500 R-Sq = 81.5% R-Sq(adj) = 67.6%

 

Analysis of Variance

Source DF SS MS F P

Regression 6 1423.56 237.26 5.87 0.013

Residual Error 8 323.09 40.39

Total 14 1746.65

Limited in the amount of data available Based on the rule of 6, the minimal amount of data to be used in the model should be 84 clients NEMSYS is a small company; does not service that many clients monthly Fewer observations skews the R-squared towards 1, but you really haven’t explained the variation

Limited in the amount of data available

Based on the rule of 6, the minimal amount of data to be used in the model should be 84 clients

NEMSYS is a small company; does not service that many clients monthly

Fewer observations skews the R-squared towards 1, but you really haven’t explained the variation

Predict the monthly engineer hours required to service a prospective client AMH = 27.0 - 14.1 (1) + 0.492 (20) + 0.69 (2) + 5.53 (1) - 13.0 (0) + 0.201 (2 2 ) = 30.45 * $85/hour = $2,588.59 Prediction interval: (16.59, 43.43) * $85/hour = ($1,410.15, $3,691.55) Conclusion: more data needed Better objectify certain cost factors YES Utilize results to assist NEMSYS in increasing efficiency and/or effectiveness YES

Predict the monthly engineer hours required to service a prospective client

AMH = 27.0 - 14.1 (1) + 0.492 (20) + 0.69 (2) + 5.53 (1) - 13.0 (0) + 0.201 (2 2 ) = 30.45 * $85/hour = $2,588.59

Prediction interval: (16.59, 43.43) * $85/hour = ($1,410.15, $3,691.55)

Conclusion: more data needed

Better objectify certain cost factors

YES

Utilize results to assist NEMSYS in increasing efficiency and/or effectiveness

YES

Used a squared predictor Get more data

Used a squared predictor

Get more data

 

Add a comment

Related presentations

Canvas Prints at Affordable Prices make you smile.Visit http://www.shopcanvasprint...

30 Días en Bici en Gijón organiza un recorrido por los comercios históricos de la ...

Con el fin de conocer mejor el rol que juega internet en el proceso de compra en E...

With three established projects across the country and seven more in the pipeline,...

Retailing is not a rocket science, neither it's walk-in-the-park. In this presenta...

What is research??

What is research??

April 2, 2014

Explanatory definitions of research in depth...

Related pages

Connect by Nemsys, Toledo Ohio IT Services

Connect by Nemsys is Toledo Ohio's premier IT solution including Hardware, Software, Tech Support, And Training.
Read more

Multiple Regression - Android Apps und Tests - AndroidPIT

Multiple Regression. Business Compass LLC. Screenshots. 0. 0. ... Calculates beta, residuals, parameter variance and regression variance 2.
Read more

Multiple Linear Regression | Statistically Significant ...

Multiple linear regression using SPSS is one of the many statistical methods I can use for your dissertation results chapter.
Read more

Regression | Simple Regression | Multiple Regression

Regression android, BlackBerry and iOS (iPhone, iPad and iTouch) App Calculates simple and multiple regression
Read more

Chapter 305 Multiple Regression - NCSS | Statistical Software

Multiple Regression 305-8 © NCSS, LLC. All Rights Reserved. Multiple Regression Checklist This checklist, prepared by a professional statistician, ...
Read more

Multiple Regression

Multiple Regression Android, BlackBerry and iOS (iPhone, iPad and iTouch) app calculates beta, residuals, parameter variance and regression variance
Read more

Simple & Multiple Regression - Android Apps on Google Play

Simple & Multiple Regression. Business Compass LLC - January 1, 2010-Unrated. Productivity. $4.99 Buy. Add to Wishlist . ... Business Compass ...
Read more

Traditional Conjoint Analysis with Excel - Survey Software ...

... Research Publishers LLC. ... A traditional conjoint analysis may be thought of as a multiple regression ... Conjoint analysis with multiple regression ...
Read more