Are there any suggestions for how I might help them learn about multiple regressions using Office for the Mac, without their having to download any third party software?
This thread is locked. You can follow the question or vote as helpful, but you cannot reply to this thread. I have the same question 9.
Mike Middleton Replied on September 12, A I think the best approach is to follow Microsoft's recommendation. That is, have the students download the free StatPlus: The experience will be very similar to the Regression tool that's available with the Windows Excel Data Analysis add-in.
But there's no friendly interface, the results are not labelled, and no charts are created automatically. Thanks for marking this as the answer.
enter site How satisfied are you with this reply? Thanks for your feedback, it helps us improve the site.
How satisfied are you with this response? KGA17 Replied on November 22, Click on the "Labels" check box to tell Excel that the first row of your data contains data labels. If you didn't enter a header row, leave this box unchecked.
Click on the "Output Range" radio button in the Output Options section of the dialog box and enter a data range in the entry field to identify a location in your current worksheet for the output of your analysis. Use the "Collapse Dialog" and "Restore Dialog" buttons to click through your worksheet and identify where to put your results.
Select the "New Worksheet Ply" radio button to place your results in a new sheet within your workbook, or choose "New Workbook" to put the results in a new file. Choose options from the Residuals section of the Regression dialog box. Residuals summarize the statistical output of the analysis on a case-by-case basis, comparing the prediction derived from the regression equation to the difference between it and the actual score.
Skip to main content. Excel Data Analysis Microsoft: Microsoft Excel. KGA17 Replied on November 22, The correlation coefficient can be any value between -1 and 1, and its absolute value indicates the relationship strength.
Standardized Residuals adjust the standard deviation of Residuals to a value of 1. Tick the check box in front of the Plot options to graph your results. The Residual Plot graphs your residuals, and the Line Fit Plot compares the regression's prediction to its actual output. Click on the "OK" button at the right of the Regression dialog box to process your regression.
View your results in the location you specified, either on your current worksheet, elsewhere in your document or in another file. Elizabeth Mott has been a writer since Mott has extensive experience writing advertising copy for everything from kitchen appliances and financial services to education and tourism.
Skip to main content. Tips The "Collapse Dialog" and "Restore Dialog" buttons replace each other on a context-sensitive basis. If you can't locate the Analysis ToolPak and Excel prompts you to install it, click on the "Yes" button to authorize its installation. The data analysis functions in the Analysis ToolPak only operate in one worksheet out of an Excel document.
Look on the first of a set of grouped worksheets for your results. You must recalculate your analysis for the rest of the worksheets in the group. Warning You must use at least three variables to perform a multivariate regression. References 7 Jeremy Miles: Excel Regression Analysis AddictiveTips: Excel Data Analysis Microsoft: Quick Start: Activate and Use an Add-In Microsoft: Add or Remove Add-Ins Microsoft: Load the Analysis ToolPak.
Resources 7 Microsoft: Multiple Regression Handbook of Biological Statistics: Types of Variables Jeremy Miles: