Data Analysis Assignment

Anonymous
timer Asked: Feb 6th, 2019
account_balance_wallet $30

Question Description

Data Analysis Assignment

Your submitted document should include the following items. Points will be deducted if the following are not included.

  1. Type your Nameand STAT with your correct section number (e.g. STAT -xxx) right justified and then Data Analysis Assignment #1centered on the top of page 1 below your name the begin your document.
  2. Number your pages across your entire solutions document.
  3. Your document should include the ANSWERS ONLYwith each answer labeled by its corresponding number and subpart. Keep the answers in order. Do notinclude the questions in your submitted document.
  4. Generate all requested graphs and tables using StatCrunch.

Unformatted Attachment Preview

Movie Month Viewed Theater Chain Genre Viewer Rating Maze Runner:January The Death CureAngelika SciFi/Fantasy Disliked The Shape of Water February Angelika SciFi/Fantasy Liked Lady Bird February Angelika Drama Liked The Greatest Showman February Angelika Drama Liked Coco February Independent Children's/Animated Liked Jumanji: Welcome February To The Jungle Regal Action/Adventure Liked Brazil February Angelika SciFi/Fantasy Disliked Three Billboards February Outside Ebbing, Angelika Missouri Drama Liked Annihilation February Angelika SciFi/Fantasy Disliked Black PantherMarch Angelika Action/Adventure Liked Early Man March Regal Children's/Animated Disliked Red Sparrow March Angelika Drama Liked A Wrinkle In Time March AMC SciFi/Fantasy Disliked Game Night March AMC Comedy Liked 2018 Oscar Nominated March Short Films: Independent Animated Children's/Animated Liked Hurricane Heist March Independent Action/Adventure Liked Tomb Raider March Angelika Action/Adventure Liked Blockers April Angelika Comedy Disliked Death of StalinApril Independent Comedy Liked Isle of Dogs April Angelika Children's/Animated Liked Leisure SeekerApril Independent Drama Liked Avengers: Infinity AprilWar Angelika Action/Adventure Liked Ready Player One May Regal SciFi/Fantasy Liked Deadpool 2 May Angelika Action/Adventure Liked Solo: A Star Wars MayStory AMC SciFi/Fantasy Liked Life of the Party May Regal Comedy Disliked Rampage May AMC Action/Adventure Liked Book Club May Regal Comedy Liked Overboard June AMC Comedy Liked A Quiet Place June AMC Horror/ThrillerLiked Action Point June Regal Comedy Disliked Incredibles 2 June AMC Children's/Animated Disliked Tag June AMC Comedy Liked Won't You Be June My Neighbor? Angelika Drama Liked Ocean's 8 June Angelika Action/Adventure Liked Hearts Beat Loud June Angelika Drama Liked The Catcher Was JuneA Spy Independent Action/Adventure Liked Jurassic World: June Fallen KingdomAngelika SciFi/Fantasy Liked Sicario Day of July the Soldado AMC Mystery/Crime Liked American Animals July Regal Mystery/Crime Liked Gotti July Regal Mystery/Crime Liked Boundaries July Angelika Drama Liked Ant-Man and July the Wasp Regal Beatles YellowJuly Submarine 50thAngelika Anniversary Three IdenticalJuly Strangers Angelika Leave No Trace July Angelika Eighth Grade July Angelika Skyscraper July AMC Blindspotting July Regal Sorry To Bother July You Landmark Don't Worry, He JulyWon't Get FarAngelika On Foot Teen Titans GO! August To The MoviesAMC Hotel Transylvania August 3 AMC Mamma Mia: August Here We Go Again! Angelika The Spy Who Dumped August Me Regal Mission Impossible August- Fallout Landmark The Equalizer August 2 AMC The Darkest Minds August Regal Blackkklansman August Angelika Christopher Robin August AMC The Meg August AMC Puzzle August Angelika Crazy Rich Asians August AMC Midsummer Night's AugustDream Landmark Dog Days August AMC Star Trek II: The August Wrath of KhanAngelika Alpha August AMC The Captain August Landmark Juliet, Naked August Angelika The Happytime August Murders Angelika Skate KitchenAugust Landmark Support The Girls August Landmark The Wife August Angelika Mile 22 August Regal Papillon August Angelika Operation Finale August Angelika A.X.L. September Regal Searching September AMC Nico, 1988 September Landmark The BookshopSeptember Independent The Little Stranger September Angelika We The Animals September Landmark Peppermint September Regal Kin September AMC The Predator September Angelika Action/Adventure Liked Children's/Animated Liked Drama Liked Drama Liked Drama Liked Action/Adventure Liked Drama Liked SciFi/Fantasy Liked Drama Liked Children's/Animated Liked Children's/Animated Liked Comedy Liked Comedy Liked Action/Adventure Liked Action/Adventure Liked Action/Adventure Liked Drama Liked Children's/Animated Liked Action/Adventure Liked Drama Liked Comedy Liked Comedy Liked Comedy Liked SciFi/Fantasy Liked Action/Adventure Disliked Drama Disliked Comedy Liked Comedy Liked Drama Liked Comedy Liked Drama Liked Action/Adventure Liked Mystery/Crime Liked Drama Liked Children's/Animated Disliked Mystery/Crime Liked Drama Disliked Drama Liked Horror/ThrillerDisliked Drama Disliked Action/Adventure Liked SciFi/Fantasy Liked SciFi/Fantasy Liked White Boy RickSeptember Angelika A Simple FavorSeptember Independent The House With September A Clock In Its Walls Regal Assassination September Nation Angelika Life Itself September Regal Love, Gilda September Landmark Hell Fest October AMC The Sisters Brothers October Angelika Night School October Regal Little WomenOctober Regal The Old Man & October the Gun Angelika Colette October Angelika A Star is Born October Regal Venom October Angelika The Oath October Angelika Smallfoot October AMC Bad Times at the October El Royale Regal Goosebumps 2: October Haunted Halloween Regal First Man October AMC Halloween October AMC The Happy Prince October Angelika Free Solo October Angelika Can You Ever Forgive OctoberMe? Angelika London FieldsOctober Regal Johnny EnglishOctober Strikes Again AMC NT Live: Frankenstein October Angelika Mid90s October Angelika Hocus Pocus October AMC The Nun November Independent Beautiful Boy November Angelika Hunter Killer November AMC A Private WarNovember Angelika Bohemian Rhapsody November Landmark Girl in the Spider's November Web Landmark Boy Erased November Angelika The Ballad of Buster November Scruggs Landmark Overlord November Angelika Green Book November AMC Bohemian Rhapsody November AMC Widows November AMC Ralph Break the November Internet AMC Fantastic Beasts: November The Grimes ofAMC Grindelwald At Eternity's Gate November Landmark Mystery/Crime Disliked Mystery/Crime Liked Children's/Animated Disliked Action/Adventure Disliked Drama Liked Comedy Liked Horror/ThrillerDisliked Drama Liked Comedy Disliked Drama Liked Mystery/Crime Liked Drama Disliked Drama Liked Action/Adventure Liked Comedy Disliked Children's/Animated Liked Mystery/Crime Liked Children's/Animated Liked Drama Disliked Horror/ThrillerLiked Drama Disliked Drama Liked Drama Liked Mystery/Crime Liked Comedy Liked Horror/ThrillerLiked Drama Liked Children's/Animated Liked Horror/ThrillerLiked Drama Disliked Action/Adventure Liked Drama Disliked Drama Liked Mystery/Crime Liked Drama Liked Comedy Liked Action/Adventure Liked Comedy Liked Drama Liked Mystery/Crime Liked Children's/Animated Liked Action/Adventure Liked Drama Disliked The FavouriteNovember Landmark Robin Hood November Independent The Nutcracker November and the Four Realms AMC Instant FamilyNovember AMC The Front Runner December Regal Dr. Seuss' TheDecember Grinch AMC The King and I:December Live Regal Creed II December AMC Anna and the December Apocalypse AMC White Christmas December AMC 2 December AMC Spider-Man: Into December the Spider-Verse AMC Once Upon a Deadpool December AMC The Mule December AMC Mary Queen of December Scots Angelika Mortal Engines December AMC Vox Lux December Angelika Ben is Back December Angelika Mortal Engines December AMC Mary PoppinsDecember Returns AMC Second Act December AMC Aquaman December AMC Bumblebee December AMC Holmes and Watson December AMC Vice January AMC If Beale StreetJanuary Could Talk Angelika Welcome to Marwen January AMC Escape Room January AMC Bumblebee January AMC On the Basis ofJanuary Sex AMC Aquaman January AMC Replicas January AMC Destroyer January Angelika Green Book January AMC A Star is Born January AMC A Dog's Way Home January AMC Cold War January Angelika Stan and OllieJanuary AMC The Upside January AMC Glass January AMC The Lego Movie January 2: The SecondAMC Part Comedy Liked Action/Adventure Liked Children's/Animated Disliked Comedy Liked Drama Liked Children's/Animated Liked Drama Disliked Drama Liked Comedy Liked Comedy Liked SciFi/Fantasy Disliked Children's/Animated Liked Action/Adventure Liked Mystery/Crime Liked Drama Disliked SciFi/Fantasy Liked Drama Liked Drama Liked SciFi/Fantasy Liked Children's/Animated Disliked Comedy Liked SciFi/Fantasy Liked SciFi/Fantasy Liked Comedy Disliked Drama Liked Drama Disliked Drama Liked Horror/ThrillerLiked SciFi/Fantasy Liked Drama Liked SciFi/Fantasy Liked SciFi/Fantasy Disliked Mystery/Crime Liked Comedy Liked Drama Liked Children's/Animated Disliked Drama Liked Comedy Liked Comedy Liked Horror/ThrillerLiked Children's/Animated Liked Data Analysis Assignment Your submitted document should include the following items. Points will be deducted if the following are not included. 1. Type your Name and STAT with your correct section number (e.g. STAT -xxx) right justified and then Data Analysis Assignment #1 centered on the top of page 1 below your name the begin your document. 2. Number your pages across your entire solutions document. 3. Your document should include the ANSWERS ONLY with each answer labeled by its corresponding number and subpart. Keep the answers in order. Do not include the questions in your submitted document. 4. Generate all requested graphs and tables using StatCrunch. Elements of good technical writing: Use complete and coherent sentences to answer the questions. Graphs must be appropriately titled and should refer to the context of the question. Graphical displays must include labels with units if appropriate for each axis. Units should always be included when referring to numerical values. When making a comparison you must use comparative language, such as “greater than”, “less than”, or “about the same as.” Ensure that all graphs and tables appear on one page and are not split across two pages. Type all mathematical calculations when directed to compute an answer ‘by-hand.’ Pictures of actual handwritten work are not accepted on this assignment. When writing mathematical expressions into your document you may use either an equation editor or common shortcuts such as: x can be written as sqrt(x), p̂ can be written as p-hat, x can be written as x-bar. Problem 1: 2018 Movies Moviepass is a subscription service that allows users to see one movie per a day at select theaters. AMC Theatres released their own movie subscription service called A-List to compete with Moviepass which allows users to see up to three movies per a week. Raw data was collected from one user who purchased an annual Moviepass subscription in January 2018 and subscription to A1 List in November 2018. The dataset found in our StatCrunch Group presents 169 movies seen along with other variables describing each movie. The data set is called “2018 Movies.” a) Use StatCrunch to create a one-way table for the variable “Genre” using both counts and percentages. Select Stat → Tables → Frequency and select both ‘Frequency’ and ‘Percent of total’ in the Statistic(s) box by holding down the Ctrl Key (Command Key on Macs) when making these selections. Copy your table into your document and then manually round the values in the ‘Percent of total” column to two decimal places in the StatCrunch table that you have copied into your document. b) Interpret your findings from the table in part (a) by identifying the least and most popular company by percent of total. Use complete sentences with context and include the genre and percentage in the sentences. c) Use StatCrunch to generate a two-way table for the variables “Genre” and “Viewer Rating”. Go to Stat → Tables → Contingency → With Data (since you have the raw data in StatCrunch). Select “Genre” as your row variable and “Viewer Rating” as your column variable. In the display box, select only Percent of Total. Lastly, unclick (or deselect) “ChiSquare test for independence” since it is highlighted by default by holding the Ctrl key and clicking on it. Copy your table into your document. d) How many and what percentage of the 169 movies did the viewer dislike? Answer this question in a complete sentence. e) What values are the same when looking at both your one-way table and your two-way table? Be specific if referencing rows or columns. f) Now, create two more two-way tables keeping “Genre” as your row variable and “Viewer Rating” as your column variable. One table needs to include row percentages and the other needs to include column percentages. To do this, change what you select in the display box from percent of total (in part (c)) to row percent for the first table and column percent for the second table. Include both tables in your document. g) Specifically interpret the meaning of the row percentage found in the “Children’s/Animated” and “Liked” cell. Note that there are 14 movies in that cell. h) Now, specifically interpret the meaning of the column percentage found in the “Children’s/Animated” and “Liked” cell. Note that there are 14 movies in that cell. Problem 2: 2018 Movies Revisited Which genre is most popular among the 169 movies seen? Use the “2018 Movies” data set posted in our StatCrunch group to answer the following questions. 2 a) Using the variable named “Genre”, produce a relative frequency bar chart using Graph → Bar Plot → With Data. Please properly label axes and provide a meaningful title and copy it into your document. b) Using the variable “Genre”, produce a relative frequency Pareto chart. Begin with your bar chart, and edit it by changing “Order by” to Count Descending. Properly title and label your graph and copy it into your document. c) Using the variable “Genre”, produce a Pie Chart using Graph → Pie Chart → With Data. Add an appropriate title and copy this entire graph including the legend into your document. d) Use the three graphs to answer the question: Which genre of movie did this individual see the most of? Present both the count and the proportion and write your answer in one sentence. e) Now produce two grouped relative frequency bar charts (to copy to your document) by following the directions below. Go to Graph → Bar Plot → With Data. For the first grouped bar chart, graph the variable “Viewer Rating” and group by “Genre.” To “group by” click the arrow next to Group by box (the third box down) and select the variable you are asked to group by. In the Type box (5th box down from the top) choose relative frequency within category. Title these graphs clearly. You may keep the default labels for the x and y-axis. For the second grouped bar chart, graph the variable “Genre” and group by “Viewer Rating.” In the Type box (5th box down from the top) choose relative frequency within category. Title these graphs clearly. You may keep the default labels for the x and y-axis. f) Compare the graph variable among the categories of the genres. Describe what you see from each graph in one sentence each. Specifically with the graph grouped by Viewer Rating, revisit your answer to 1(h) in your comment. See next page for Problem 3 Problem 3: Los Angeles Metro Bike Share On July 7, 2016, the Los Angeles County Metropolitan Transportation Authority launched a bicycle sharing system called Metro Bike Share. The system uses a fleet of about 1,400 bikes and includes 93 stations in Downtown Los Angeles, Venice, and the Port of Los Angeles. It is the first bike share system in the United States to be integrated as part of the city’s existing public transit system. 3 The “Metro Bike Share” data set includes a random sample of 300 trips lasting between one and 60 minutes. Twelve variables are included for each observation. The Duration variable indicates the length of the trip in minutes. a) Create a frequency histogram for the variable “Duration” by using Graph → Histogram. Properly title and label your graph and copy it into your document. b) Interpret the shape of this distribution in one complete sentence. c) Use StatCrunch to obtain the sample size, mean, and standard deviation for the “Duration” variable by using Stat → Summary Stats → Columns. Note: in the Statistics box, select the summary statistics listed above in the exact order given. Copy the entire table into your document and manually round each value to two decimal places. d) Use StatCrunch to obtain the five number summary and the IQR for the “Duration” variable (the five number summary includes Min, Q1, Median, Q3, Max). Go to Stat → Summary Stats → Columns to obtain these values. Note: in the Statistics box, select the summary statistics listed above in the exact order given. Copy the entire table into your document and manually round each value to two decimal places. e) Choose the appropriate summary statistics for center and spread (presented in either 3c or 3d) based on your stated shape of the distribution in 3b. f) Use your summary statistics from part 3d and determine the fences used to mathematically identify outliers for the “Duration” variable. To do this, show all steps in your calculations manually including how you obtained the upper and lower fences. Please type your work and calculations. g) Construct a horizontally oriented boxplot of the “Duration” variable by using Graph → Boxplot. To do this, click the “Draw boxes horizontally” box. Properly title and label and copy this graph into your document. h) How many outliers do you identify (please use both the boxplot and your results from 3f)? Write your response in a complete sentence. Problem 4: SAT Scores This data set presents SAT Verbal and Math scores for a random sample of 300 individuals. In addition, the individual’s gender and college is recorded. The sample was collected from one of six colleges (numbered 1 – 6). The data set is called “SAT Scores.” a) Construct two relative frequency histograms using the “Math” variable (one for Males and one for Females). To do this, go to Graph → Histogram. Select Math to enter it in the graph box and then click the arrow in the “Group by:” box and select Gender. Properly title and label your graphs. Finally, below the titling area, under “For multiple graphs” change Columns per page from 1 to 2 and click Compute! Once the graph is computed, click the three lines in the bottom left of the leftmost graph. Select x-axis and change the minimum 4 to 250 and select the y-axis and change the maximum to 0.24. (I have to do this to have each graph have the same sizing for the x and y axes)*. Copy and paste your graphs into your document. b) Describe the shape of each distribution in context in one sentence each. c) Use StatCrunch to obtain sample size (n), the mean, and standard deviation of the “Math” variable by Gender (using “Group by:”) Copy and paste the table into your document. Round your answers to whole numbers in your document. For parts 4d-4f, determine how well the Empirical Rule does in predicting the percentage of observations within some number of standard deviations of the mean. d) Use your rounded summary statistics for females from part 4c to calculate the interval corresponding to one, two, and three standard deviations about the mean SAT Math Score. Type your work showing how you obtained these intervals. Round the endpoints of the final intervals correctly to whole numbers and clearly label and list these three intervals in your document as shown below: 68% interval (lower value, upper value) 95% interval (lower value, upper value) 99.7% interval (lower value, upper value) e) Use StatCrunch to determine the count and percentage of observations falling in each of these intervals by following the instructions listed below or using another appropriate counting method. Properly label and list these counts and percentages in your document. Start in the “Female Math SAT Scores” data set (found in your StatCrunch Group). Go to Data → Row Selection → Interactive Tools. In the slider selectors box, click the variable Math into the variable box. Then Click compute. The box that appears has a slider under the words Math that allows you to create ranges of scores that you determined in 4d. Use the slider to obtain the co ...
Purchase answer to see full attachment

Tutor Answer

mickeygabz
School: UCLA

See...

flag Report DMCA
Review

Anonymous
Goes above and beyond expectations !

Similar Questions
Hot Questions
Related Tags
Study Guides

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors