### Create a StudySoup account

#### Be part of our community, it's free to join!

Already have a StudySoup account? Login here

# Business Statistics DSC 330

UO

GPA 3.66

### View Full Document

## 17

## 0

## Popular in Course

## Popular in Decision Sciences

This 5 page Class Notes was uploaded by Camren Kiehn on Tuesday September 8, 2015. The Class Notes belongs to DSC 330 at University of Oregon taught by Iain Pardoe in Fall. Since its upload, it has received 17 views. For similar materials see /class/187207/dsc-330-university-of-oregon in Decision Sciences at University of Oregon.

## Similar to DSC 330 at UO

## Reviews for Business Statistics

### What is Karma?

#### Karma is the currency of StudySoup.

#### You can buy or earn more Karma at anytime and redeem it for class notes, study guides, flashcards, and more!

Date Created: 09/08/15

Applied Regression Modeling A Business Approach Computer software help Excel Microsoft Excel is a commercial spreadsheet package with an easytouse graphical user interface that is capable of carrying out a few basic statistical analyses Further information is available at wwwmicrosoft comexce1 The following instructions are based on Microsoft Of ce Excel 2003 for Windows The book website contains supplementary material for other versions of Excel This section contains less material than the preceding sections for SPSS Minitab SAS and R because it is not possible to easily carry out many of the techniques discussed in this book using Excel However there are a number of addon modules available for Excel that can improve its statistical analysis capabilities for example StatTools available at wwwpalisadecomstattools and Lumenaut Statistics Package available at www 1umenaut comstatist ics htm Getting started and summarizing univariate data 1 Change Excel s default options by selecting Tools gt Options Make sure Excel s Data Analysis functions are available by selecting Tools gt AddIns and checking Analysis TooIPak To open an Excel data le select File gt Open Output can be copied and pasted from Excel to a word processor like Microsoft Word Graphs can also easily be copied and pasted to other applications 2 You can access help by selecting Help gt Microso Excel Help For example to nd out about scatterplots type scatter plot in the search box I To transform data or compute a new variable type for example LNX for the natural logarithm of X and X2 foer To create indicator dummy variables from a qualitative variable type for exam ple IFXquotIeveIquot 1 0 where X is the qualitative variable and quotlevelquot is the name of one of the categories in X Repeat for other indicator variables if necessary 4 Calculate descriptive statistics for quantitative variables by selecting Tools gt Data Analysis gt Descriptive Statistics Select the Input Range to include the variables of interest check Labels in first row if appropriate and check Summary statistics 5 Create contingency tables or crosstabulations for qualitative variables by selecting Data gt PivotTabIe and PivotChart Report Select Microso Office Excel list or database as the data to be analyzed and PivotTabIe as the report to be created Next select an appropriate data range and put the PivotTabIe report in a new worksheet Drag one qualitative variable to the Column Fields space another qualitative variable to the Row Fields space and drag some other convenient variable to the Data Items space The resulting table should show sums of the variable in the Data Items for different combinations of the qualitative variable categories To l so change the sums to frequencies doubleclick on cell A3 and change Sum to Count To calculate row and column percentages click the Options button If you have quantitative variables and qualitative variables you can calculate de scriptive statistics for cases grouped in different categories by creating a PivotTable see computer help 5 and doubleclicking on cell A3 to select different summary functions Excel does not appear to offer an automatic way to create a stemandleaf plot To make a histogram for a quantitative variable select Tools gt Data Analysis gt His togram Select the Input Range to include the variable of interest check Labels if appropriate and check Chart Output To make a scatterplot with two quantitative variables select Insert gt Chart gt XY Scatter In Step 2 of the Chart Wizard click on the Series tab select the appropriate data ranges for the X Values Y Values and Name boxes and click Finish Excel does not appear to offer an automatic way to create a scatterplot matrix Excel does not appear to offer an automatic way to create a scatterplot with different colorssymbols marking the categories in a qualitative variable However you can identify individual cases in a scatterplot by hovering over them To make a bar chart for cases in different categories rst create a PivotTabIe see computer help 5 of cell frequencies Then select Insert gt Chart to create a bar chart You may need to subsequently click the Chart Wizard tool to change the chart type e g from stacked bars to clustered bars The bars can also represent various summary functions for a quantitative variable For example doubleclick on the cell that says Count of in the PivotChart worksheet and change it to Average to make the bar chart represent Means ll Excel does not appear to offer an automatic way to create boxplots 12 Excel can make a QQplot also known as a normal probability plot for a quanti l tative variable automatically but only though the Regression tool For example select Tools gt Data Analysis gt Regression then select the Input Y Range to include the response variable select the Input X Range to include the predictor variables and check Labels if appropriate The predictor variables should be in adjacent columns in the spreadsheet for this to work Finally check Normal Probability Plotsbefore hitting OK p J QQplotfoi veuld Ulc in 39 To compute a con dence interval for a univariate population mean select Tools gt Data Analysis gt Descriptive Statistics Select the Input Range to include the variable of interest check Labels in first row if appropriate check Summary statistics check Confidence Level for Mean and type the con dence level into the box The resulting Confidence Level value represents the uncertainty in the intervals In other words the interval goes from the sample mean minus this uncertainty up to the sample mean plus this uncertainty 14 Excel does not appear to offer an automatic way to do a hypothesis test for a univariate population In ean It is possible to do the test by hand calculation using Excel descriptive statistics output and appropriate percentiles from a tdistribution Simple linear regression 15 To t a simple linear regression model ie nd a least squares line select Tools gt Data Analysis gt Regression Select the Input Y Range to include the response variable select the Input X Range to include the predictor variable and check Labels if appropriate Just hit OK for nowithe other items in the dialog box are addressed below 16 To add a regression line or least squares line to a scatterplot select the plot by clicking on it and select Chart gt Add Trendline This brings up another dialog in which you need to make sure Linear is selected under TrendRegression type Hit OK to add the least squares line to the plot 17 In tting a simple linear regression model see computer help 15 Excel automati cally nds 95 con dence intervals for the regression parameters This applies more generally to multiple linear regression also 18 Excel does not appear to offer an automatic way to nd a con dence interval for the mean of Y at a particular value of X in a linear regression mode 19 Excel does not appear to offer an automatic way to nd a prediction interval for an individual value of Y at a particular value of X in a linear regression model Multiple linear regression 20 To t a multiple linear regression model select Tools gt Data Analysis gt Regression Select the Input Y Range to include the response variable select the Input X Range to include the predictor variables and check Labels if appropriate The predictor variables should be in adjacent columns in the spreadsheet for this to work Q I To add a quadratic regression line to a scatterplot select the plot by clicking on it and select Chart gt Add Trendline This brings up another dialog in which you need to make sure Polynomial with Order 2 is selected under TrendRegression type Hit OK to add the quadratic regression line to the plot 22 Excel does not appear to offer an automatic way to create a scatterplot with separate regression lines for subsets of the samp e 23 Excel does not appear to offer an automatic way to nd the Fstatistic and associated N N pvalue for a nested model Ftest in multiple linear regression It is possible to calculate these quantities by hand using Excel regression output and appropriate percentiles from a Fdistribution Excel does not appear to offer an automatic way to save studentized residuals in a multiple linear regression model However it does calculate crude standardized residuals which it de nes as ordinary residuals divided by their standard deviation In particular select Tools gt Data Analysis gt Regression Select Input Y Range to include the response variable select Input X Range to include the predictor variables and check Labels if appropriate Predictor variables should be in adjacent columns in the spreadsheet for this to work Finally check Standardized Residuals before hitting OK Excel does not appear to offer an automatic way to add a loess tted line to a scatter plot 26 Excel does not appear to offer an automatic way to save leverages in a multiple linear N N N I I regression model Excel does not appear to offer an automatic way to save Cook s distances in a multiple linear regression mode To create some residual plots automatically in a multiple linear regression model select Tools gt Data Analysis gt Regression Select the Input Y Range to include the response variable select the Input X Range to include the predictor variables and check Labels if appropriate The predictor variables should be in adjacent columns in the spreadsheet for this to work Finally check Residual Plots before hitting OK to create residual plots with each predictor variable on the horizontal axis To create residual plots manually rst create standardized residuals see computer help 24 and then construct scatterplots with these standardized residuals on the vertical axis In particular you should plot them against the Excelprovided tted predicted values for the regression To create a correlation matrix of quantitative variables useful for checking potential multicollinearity problems select Tools gt Data Analysis gt Correlation Select the Input Range to include the variables of interest and check Labels in First Row if appropriate The variables should be in adjacent columns in the spreadsheet Excel does not appear to offer an automatic way to nd variance in ation factors in a multiple linear regression model To draw a predictor effect plot for graphically displaying the effects of quantitative predictors in multiple linear regression rst create a variable representing the effect say Xleffect see computer help 3ithis variable must just involve Xl eg l3Xl4X12 Then sort the X1 variable in ascending order using Data gt Sort and select Insert gt Chart gt XY Scatteriselect the plot with data points connected by smoothed lines without markers In Step 2 of the Chart VWzard click on the Series tab select the appropriate data ranges for the XVaIues sorteXm variable Y Values Xleffect variable and Name boxes and click Finish Excel does not appear to offer an automatic way to create more complex predictor effect plots say with separate lines representing different subsets of the sample

### BOOM! Enjoy Your Free Notes!

We've added these Notes to your profile, click here to view them now.

### You're already Subscribed!

Looks like you've already subscribed to StudySoup, you won't need to purchase another subscription to get this material. To access this material simply click 'View Full Document'

## Why people love StudySoup

#### "Knowing I can count on the Elite Notetaker in my class allows me to focus on what the professor is saying instead of just scribbling notes the whole time and falling behind."

#### "I signed up to be an Elite Notetaker with 2 of my sorority sisters this semester. We just posted our notes weekly and were each making over $600 per month. I LOVE StudySoup!"

#### "I was shooting for a perfect 4.0 GPA this semester. Having StudySoup as a study aid was critical to helping me achieve my goal...and I nailed it!"

#### "Their 'Elite Notetakers' are making over $1,200/month in sales by creating high quality content that helps their classmates in a time of need."

### Refund Policy

#### STUDYSOUP CANCELLATION POLICY

All subscriptions to StudySoup are paid in full at the time of subscribing. To change your credit card information or to cancel your subscription, go to "Edit Settings". All credit card information will be available there. If you should decide to cancel your subscription, it will continue to be valid until the next payment period, as all payments for the current period were made in advance. For special circumstances, please email support@studysoup.com

#### STUDYSOUP REFUND POLICY

StudySoup has more than 1 million course-specific study resources to help students study smarter. If you’re having trouble finding what you’re looking for, our customer support team can help you find what you need! Feel free to contact them here: support@studysoup.com

Recurring Subscriptions: If you have canceled your recurring subscription on the day of renewal and have not downloaded any documents, you may request a refund by submitting an email to support@studysoup.com

Satisfaction Guarantee: If you’re not satisfied with your subscription, you can contact us for further help. Contact must be made within 3 business days of your subscription purchase and your refund request will be subject for review.

Please Note: Refunds can never be provided more than 30 days after the initial purchase date regardless of your activity on the site.