Background: This course is all about data visualization. However, we must first have some understanding about the dataset that we are using to create the visualizations. Assignment:
· Use RStudio to generate a word document with basic data analysis of the following dataset: dataset_price_personal_computers. csv
· Create a summary of stats for the dataset. (provide a screen shot)
· Create a correlation of stats for the dataset. (provide a screen shot) (Hint: Transform may be needed)
· What is the Min, Max, Median, and Mean of the Price? (provide a screen shot)
· What is the correlation values between Price, Ram, and Ads? (provide a screen shot)
· Create a subset of the dataset with only Price, CD, and Premium. (provide a screen shot)
· Create a subset of the dataset with only Price, HD, and Ram where Price is greater than or equal to $1750. (provide a screen shot)
· What percentage of Premium computers were sold? (provide a screen shot)(Hint: Categorical analysis)
· How many Premium computers with CDs were sold? (provide a screen shot)(Hint: Contingency table analysis)
· How many Premium computers with CDs priced over $2000 were sold? (provide a screen shot)(Hint: Conditional table analysis)

Ticker services began operations in 2015 and maintains long-term investments in available-for-sale securities. the year-end cost and fair values for its portfolio of these investments follow.portfolio of available-for-sale securities cost fair valuedecember 31, 2015 $ 369,060 $ 357,988 december 31, 2016 420,728 445,972 december 31, 2017 572,190 676,901 december 31, 2018 864,007 768,966 prepare journal entries to record each year-end fair value adjustment for these securities.calculation adjustment required to fair value adjustment.12/31/15 existing balance in fair value adjustment-afs (lt) required balance in fair value adjustment-afs (lt) adjustment required to fair value adjustment-afs (lt) 12/31/16 existing balance in fair value adjustment-afs (lt) required balance in fair value adjustment-afs (lt) adjustment required to fair value adjustment-afs (lt) 12/31/17 existing balance in fair value adjustment-afs (lt) required balance in fair value adjustment-afs (lt) adjustment required to fair value adjustment-afs (lt) 12/31/18 existing balance in fair value adjustment-afs (lt) required balance in fair value adjustment-afs (lt) adjustment required to fair value adjustment-afs (lt) record the year-end adjusting entry for the securities portfolio as of december 31, 2015.date general journal debit creditdec 31, 2015 record the year-end adjusting entry for the securities portfolio as of december 31, 2016.date general journal debit creditdec 31, 2016 record the year-end adjusting entry for the securities portfolio as of december 31, 2017.date general journal debit creditdec 31, 2017 record the year-end adjusting entry for the securities portfolio as of december 31, 2018.date general journal debit creditdec 31, 2018

For each example, identify the most appropriate ctso.marilyn is a middle-school student who wants to prepare for a career in farming: pasnational ffanyfeafeajanice is a high-school student who wants to start her own business: skillsusatsapasdecaabe is a high-school student who wants to become an information technology worker: hosafcclabpanyfearene wants to teach middle-school classes: feafccladecahosa

In a high school with 3000 students, counselors are putting together a math tutoring program for the neighboring middle school. they plan to invite high school students with high average test scores to tutor middle school students, and they would like to offer gift cards to the student tutors. the counselors have a spreadsheet showing each student’s average test scores, and in order to find out how many gift cards they should purchase, the counselors need to count how many students would qualify to become tutors. which type of function would best the counselors determine the number of eligible students?