Assignment 1

xlsx

School

Chapman University *

*We aren’t endorsed by this school

Course

215

Subject

Finance

Date

Apr 3, 2024

Type

xlsx

Pages

16

Uploaded by UltraCoyote4128

Report
Numbers Sheet Name Numbers Table Name Questions Table 1 Shadow Stocks Table 1 TV Show Demand Table 1 Florida counties crime Table 1 This document was exported from Numbers. Each table was converte objects on each Numbers sheet were placed on separate worksheets. calculations may differ in Excel.
Excel Worksheet Name ed to an Excel worksheet. All other Please be aware that formula Questions Shadow Stocks TV Show Demand Florida counties crime
3 MGSC 209 Professor Brett Danaher Student Name(s): Homework Assignment 1 Instructions: You must insert your full name into the student name blank in the upper right hand corner of this worksheet (cel You may complete this assignment is groups of up to 3 students. If you are working in a team, place all studen This worksheet contains all of the questions to be answered, as well as blanks in which to answer them. You MUST place your answers in the blanks provided on THIS worksheet. This is the worksheet on which I wil Other worksheets in this document contain datasets to be used for each question. You may do anything you w check them to see how you did your work, but it is your answers in THIS worksheet that will mostly determine y Question 1 Column A indicates the name of the company. Column B indicates the exchange on which the stock is traded. Column D indicates the P/E ratio (price/earnings ratio), a metric that investors use to gauge the value of a comp a. Make a histogram for the variable P/E Ratio. For the bins, use "0 to 10", "10.01 to 20", "20.01 to 3 Paste the histogram into the blank space below - you may resize it a bit to fit it into the space. b. What is the mean P/E ratio? Mean P/E ratio = c. What is the median P/E ratio? Median P/E ratio = d. What is the mean Earnings per Share for stocks listed on OTC? How about the mean for stocks Mean Earnings per Share for OTC Stocks = Mean Earnings Per Share for AMEX Stocks = The worksheet "Shadow Stocks" contains data on 20 shadow stocks. The term shadow indicates stocks for sm Paste histogram here
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
4 e. What is the standard deviation of the Earnings per Share for all stocks? Std. Dev. of Earnings Per Share = f. What is the standard deviation of the P/E Ratio for all stocks? Std. Dev. of P/E Ratio = g. Which variable shows more variation (EPS or P/E Ratio) according to the standard deviation? h. Is there any reason that standard deviation might not be the best way to compare which variable Based on your reading of the book or our class lectures, is there a measure that might be better fo Question 2 The Worksheet "TV Show Demand" contains data on iTunes downloads and pirated downloads (using BitTorre Column A is the show name. Column B indicates total pirated downloads, and Column C indicates total paid iT For simplicity, a download of any season or episode of a particular series counts as 1 download. a. What is the mean of pirated downloads, and what is the mean of iTunes downloads? Mean Pirated Downloads = Mean iTunes Downloads = b. Which mean is higher (piracy or iTunes downloads?) and give one reason why you think this is? c. What is the standard deviation of pirated downloads? How about iTunes downloads? Std. Dev. of Pirated Downloads = Std. Dev. of iTunes Downloads = d. What is the correlation coefficient between pirated downloads and iTunes downloads? Correlation Coefficient = e. Are these two variables positively or negatively correlated?
5 f. Is this correlation strong or weak? g. Does this mean that piracy of a show increases sales of that show? Why or why not? (explain yo Question 3 The worksheet "Florida Counties Crime" contains data on 24 different counties in Florida. Column A indicates the county name. Column B indicates the crime rate, defined as the number of crimes per Column C indicates the median income in that country. Column D indicates the percent of residents in that cou Column E indicates the percentage of residents in that county who live in an urban environment (city-like enviro a. What is the mean crime rate for just the counties in which less than 40% of residents live in urban Mean Crime Rate (for countries with less than 40% urban) = b. What is the mean crime rate for just the counties in which more than 40% of residents live in urba Mean Crime Rate (for countries with more than 40% urban) = c. Calculate the correlation coefficients between crime rate and each of the other 3 variables. Correl(Crime Rate, Median Income) = Correl(Crime Rate, % High School) = Correl(Crime Rate, % Urban) = d. Let's assume that having more people dwelling in urban areas CAUSES an increase in crime rate urban areas actually foster more crime than rural areas, because the tightly packed nature of urb We note that there is a positive correlation coefficient between the % of people with a high school de tend to cause less crime in an area? Can you come up with a good explanation for why areas where
6 Question 4 In a class of 25 students, the following table shows the amount of time spend studying for a test: Study time 0 to 4 4 to 8 8 to 12 12 to 16 16 to 20 (hours) 3 7 8 5 2 In other words, 3 students spent between 0 and 4 hours studying, 7 students spend between 4 and 8 hours stu Estimate the mean study time for this sample of students given only the grouped data above. (hint, use the form Estimated mean study time = Number of students
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
7 ll K4). If you do not, you may not receive credit for your assignment! nt names on this assignment and only one of you needs to upload it to Canvas. ll base your grades. want in these worksheets in order to answer the question. I may your grade for this assignment. Column C indicates the earnings-per-share (EPS) for the stock. pany/stock. 30", "30.01 to 40", and "Greater than 40". s listed on AMEX? mall to medium-sized firms not followed closely by major brokerage houses
8 shows more variation/dispersion? or comparing which of two variables is more dispersed? ent) for 81 different television shows during a 6 week period in 2007. Tunes downloads.
9 our answer) 1000 residents. unty over age 25 who have a high school degree. onment). n areas? an areas? e. (This is, in fact, true. Other more complex studies have shown that ban areas facilitates easier crime, and because urban areas have more dispersed income ranges). egree, and the crime rate. This does not seem to make sense - wouldn't people having more education e more people have high school degrees are prone to more crime? (a concise explanation will do)
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
10 udying, and so on. mula for estimating a mean from grouped data)
11 Stock Exchange P/E Ratio Chemi-Trol OTC 0.39 27.3 Candie's OTC 0.07 36.2 TST/Impreso OTC 0.65 12.7 Unimed Pharm. OTC 0.12 59.3 Skyline Chili AMEX 0.34 19.3 Cyanotech OTC 0.22 29.3 Catalina Light. NYSE 0.15 33.2 DDL Elect. NYSE 0.1 10.2 Euphonix OTC 0.09 49.7 Mesa Labs OTC 0.37 14.4 RCM Tech. OTC 0.47 18.6 Anuhco AMEX 0.7 11.4 Hello Direct OTC 0.23 21.1 Hilite Industries OTC 0.61 7.8 Alpha Tech. OTC 0.11 34.6 Wegener Group OTC 0.16 24.5 U.S. Home &Garden OTC 0.24 8.7 Chalone Wine OTC 0.27 44.4 Eng. Support Sys. OTC 0.89 16.7 Int. Remote Imaging AMEX 0.86 4.7 Earnings Per Share
12
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
13 Series Pirated Downloads iTunes purchases 'Till Death 26631 82 24 4297711 49718 30 Rock 1179939 8010 According To Jim 48648 175 Adam-12 6107 34 Alfred Hitchcock Presents 98584 318 Alias 731363 2286 American Dad 506799 3662 Andy Barker P.I. 1468 3 Battlestar Galactica 2734506 8567 Battlestar Galactica Classic 161824 480 Beverly Hills 90210 152167 456 Bionic Woman 1976 226461 1660 Bones 636799 2883 Boston Legal 763056 3028 Brothers & Sisters 573411 1231 CSI: Crime Scene Investigation 1565368 15771 CSI: Miami 830200 5012 CSI: NY 341112 758 Cold Case 279156 1517 Criminal Minds 478212 1829 Desperate Housewives 4153120 22700 Eureka 140198 445 Everybody Loves Raymond 613027 5872 Family Guy 4549277 25998 Family Ties 78 0 Friday Night Lights 430427 3917 Ghost Whisperer 405698 2506 Grey's Anatomy 3717452 35791 Hercules: The Legendary Journeys 74012 201 Heroes 6658636 25503 House 4129241 15279 How I Met Your Mother 1378444 10096 Jericho 1303057 7622 King Of The Hill 124572 380
14 Knight Rider Classic 85027 544 Kolchak: The Night Stalker 5996 46 Law & Order 174076 855 Law & Order: Criminal Intent 181026 460 Law & Order: Special Victims Unit 264780 2195 Law & Order: Trial by Jury 4774 14 Lost 6037949 17394 MacGyver 281999 963 Magnum PI 25563 192 Medium 171169 469 Melrose Place 22214 81 Men In Trees 168390 621 Miami Vice 130770 514 Monk 241853 1191 My Name Is Earl 1420112 4507 NCIS 1107366 2696 New Adventures of Old Christine 28595 124 Numb3rs 415677 1032 Prison Break 4737619 17485 Psych 53492 131 Raines 5241 23 Rules Of Engagement 77645 226 Saved by the Bell 141212 301 Scrubs 4628258 15632 Shark 153383 1756 Sliders 122576 639 Star Trek: The Original Series 304160 3450 StarGate SG1 1592907 5495 Surface 52366 570 The A-Team 74082 502 The Black Donnellys 56927 598 The Dead Zone 152057 330 The Dresden Files 91802 918 The Incredible Hulk 1940 4 The King Of Queens 333198 3204 The Munsters 10921 25
15 The Office 3146064 9911 The Simpsons 8020982 82021 The Starter Wife 10740 25 The Unit 517476 2118 Tremors 4017 13 Twin Peaks 455693 2973 Two And A Half Men 809596 6643 Ugly Betty 696620 3681 Will And Grace 452125 2529 Without A Trace 221519 638
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
16 County Crime Rate Median Income High School Percent Urban LAFAYETTE 0 20.7 58.2 0 LEVY 45 18.8 62.8 0 GLADES 62 20.7 57.4 0 UNION 6 22.8 67.7 0 MADISON 26 18.2 56.5 20.3 JEFFERSON 36 21.8 64.1 22.3 WASHING. 21 18.3 60.9 22.9 FRANKLIN 37 17.2 59.5 30.2 COLUMBIA 69 22 69 31.1 MARION 64 22.5 69.6 39.6 SEMINOLE 56 35.6 78.5 44.4 SANTAR. 43 27.6 79.9 57.2 PASCO 42 21.5 66.9 67.4 POLK 84 25.2 68 70.3 ALACHUA 104 22.1 82.7 73.2 MONROE 89 29.4 79.7 73.2 COLLIER 55 34 79 77.6 CHARLOTTE 35 25.7 75.7 80.2 MARTIN 53 31.8 79.7 83.2 ESCAMBIA 70 25.2 76.2 85.9 HILLSBOR. 110 28.5 75.6 89.2 SARASOTA 58 29.9 71.7 92.1 STJOHNS 54 29.9 81.3 93.2 BROWARD 94 30.6 76.8 98.9