Unformatted text preview: mean, given a known/unknown population standard deviation. 6. Hypothesis testing for population mean. Calculate confidence intervals. 7. Hypothesis testing for the difference between two population means. Calculate confidence intervals. 8. Run a multi-variable linear regression and explain results. 9. Open/create a macro in Excel. Know how to write a simple macro with “if…end if” condition and “for…next” loop. Test Preparation: Go through tutorial answer keys, which have been posted in Portal. Questions in the final test will be similar to those tutorial exercises. Microsoft Excel2007 will be used in the final test. If you work on other Excel versions at home, please make sure that you are familiar with Excel2007. Other Requirements : No textbook, calculator, cell phone, or other forms of help is allowed. No formula sheet will be provided. Students are allowed to use the Help menu in Excel....
View Full Document
- Spring '11
- Statistics, UC Multimedia Lab, Carr Hall Multimedia lab