Descriptive Statistics Lab - Revised - 3

University of California, Los Angeles **We aren't endorsed by this school
Sep 3, 2023
Uploaded by BailiffFreedomHeron13 on
This is a preview
Want to read all 1 page? Go Premium today.
Already Premium? Sign in here
Descriptive Statistics Lab In the Descriptive Statistics Lab workbook, various statistics are presented for different retail companies. 1. Using the data analysis tools that we added during our initial class session, do descriptive statistics for Assets-Total, Net Income (Loss), and Sales (Net). In selecting data, include the column header. In this way, your output will include that header. Create a new spreadsheet and place all three outputs on that same spreadsheet (perhaps in A1, C1, and E1, respectively) and name the spreadsheet, Descriptive Statistics. 2. For each company, calculate two ratios: a. Return on Assets, and Return on Sales b. Remember that the word, return , in finance and ratio analysis means Net Income. c. Format each number to be a percentage and have 0 decimal places. 3. For the Return on Assets column, insert a histogram chart. You will find the histogram chart under the statistical charts icon in Excel on the Insert tab. Answer the following questions: 1. What is the standard deviation of total assets? 2. What are the minimum total assets in the retail industry in this dataset? 3. What is the number of observations in the dataset? 4. Looking at the histogram that you created... a. Which range has the highest number of companies' Returns on Assets? b. How many companies are in that range? 5. Go online and look up SIC Codes a. What is an SIC Code (not just what SIC stands for)? b. What is the range of numbers for all Retail Trade SIC codes?
Page1of 1
Uploaded by BailiffFreedomHeron13 on