[ Software | Quantitative Skills | Qualitative Skills | Vocabulary & Concepts | Site Map ]

Excel Video Series for Activity I, Problem 9      To help you with your coursework, we are posting video lessons for working with Excel, histograms, data analysis, BestFit, and confidence intervals. These lessons were designed for high speed access. They may work with a 56K modem; however, there will be delays as the videos buffer. We are working on links for 56K modem access. If you need help viewing or listening to the videos, or downloading the free plug-ins, Click Plug-ins and Video Tips. Click the Back button to return to this page. Each video runs less than ten minutes. Here is a link to the Activities Problems Download Page. Scroll down the list of links to Activity I: Problems. (The file includes all Activity I problems. This Excel Video Series corresponds to Problem 9.) Click the Back button to return to this page. Playing the Videos We recommend playing the videos in the order listed. Web to Excel: This video shows how to get data from a Web page to Excel. Here we assume that the Web page does not have a "Download as Spreadsheet file" option. We will save the Web page as text, and then import the text into Excel using the Text Import wizard. This method should always work to move data into Excel. Data Preparation: This video shows how to create a formula to format the date in an evenly spaced manner so that graphs are displayed better. Descriptive Statistics: This video shows how to name the data and calculate the usual descriptive statistics (mean, median, standard deviation) as well as the quartiles and percentiles. Histogram via Data Analysis: This video shows how to use the Data Analysis wizard to create a histogram. Histogram via Frequency Function: This video shows how to use the Frequency Function of Excel (an array function) to create a histogram. Best Fit: This video shows how to use the program BestFit to both create a histogram of the data, and to approximate the distribution of the data with a theoretical distribution. Confidence Interval: This video shows how to calculate a confidence interval for large sample sizes using Excel. This uses a different database of values than the other videos. Questions, Comments, and Concerns Your questions, comments, and concerns are important. Please review them with your instructors. If you feel an S3C helpline would be beneficial, please email the Site Coordinator.

[ Home | Help | Programs | Professors/Instructors | What's New on S³C? | Video Library ]

[ Software | Quantitative Skills | Qualitative Skills | Vocabulary & Concepts | Site Map ]

Last Updated June 12, 2003 by prp. Email comments to Site Coordinator. Privacy Statement and Site Evaluation © 2000 - 2003 University of St. Thomas and Thomas H. Ressler, Ph.D. All Rights Reserved.