1 / 35

Text Mining & Basic Calculations

Text Mining & Basic Calculations. Supplemental Resources on Class Website. Concept Map. Big Data. Implementation. Yields Business Intelligence. Design. Excel Features. Data Mining. Accuracy. Objectives. Define Big Data and Data Mining

cai
Download Presentation

Text Mining & Basic Calculations

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Text Mining & Basic Calculations Supplemental Resources on Class Website

  2. Concept Map Big Data Implementation Yields Business Intelligence Design Excel Features Data Mining Accuracy

  3. Objectives • Define Big Data and Data Mining • Explain the Accuracy principle of Spreadsheet Design • Demonstrate Excel features that support basic spreadsheet analytics.

  4. Facebook Users • 1.28 billion users worldwide • 802 million users login daily (up 21%) • 67% of Internet users are on FB • 50% of 18-24 year olds login when they wake up • 45-54 year old age group has grown 46%

  5. Facebook Content • 4.5 billion likes daily (up 67%) • 30 million photos uploaded daily • 1 in 5 page views in US • 36% users post brand-related content on their walls

  6. King of Social Media • FB accounts for 66% of social media sharing on iPhones • Users with income over $75,000 Facebook 73% Twitter 17% Pinterest 13%

  7. Facebook & e-commerce • 10 million registered small businesses • Drives 26% of referral traffic to e-commerce sites • 20% of shoppers prefer buying thru FB vs. e-commerce website • 58% of businesses see a drop in marketing costs when moving to FB

  8. Big Data • Data sets too large to process with traditional database technology

  9. Data Mining Tools • software that searches through data • uses complex statistical calculations • outputs • Trends • Patterns • Correlations • Exceptions

  10. Nestle • Nestle processes Social Media http://uk.reuters.com/article/video/idUKBRE89P07Q20121026?videoId=238680321

  11. Import • Access data not formatted as an Excel document • File type = txt or csv

  12. Import – Step 1 • File, Open, File type = All files http://www.lacoste.pamplin.vt.edu/web1504/resources/video/ss.html

  13. Import – Step 2 http://www.lacoste.pamplin.vt.edu/web1504/resources/video/ss.html

  14. Import – Step 3 • Save As File type = Excel Worksheet http://www.lacoste.pamplin.vt.edu/web1504/resources/video/ss.html

  15. Text Mining • Search • Parse • Concatenate • SEARCH • LEFT, MID, RIGHT, LEN • &

  16. SEARCH Function http://www.lacoste.pamplin.vt.edu/web1504/resources/video/ss.html

  17. LEFT Function http://www.lacoste.pamplin.vt.edu/web1504/resources/video/ss.html

  18. LEN or Length Function http://www.lacoste.pamplin.vt.edu/web1504/resources/video/ss.html

  19. RIGHT Function http://www.lacoste.pamplin.vt.edu/web1504/resources/video/ss.html

  20. MID Function http://www.lacoste.pamplin.vt.edu/web1504/resources/video/ss.html

  21. Concatenate • & is the concatenate symbol • Quotes are required around constant strings of text http://www.lacoste.pamplin.vt.edu/web1504/resources/video/ss.html

  22. Relative Cell Addressing • Relative is the default • When you copy a relative cell reference the reference will change depending on the direction and magnitude of the copy.

  23. Copy Formula with Relative Cell Addresses

  24. Formula vs. Function • Formula • created by you • = A1 + A10 • Function • keyword defined by Microsoft • =SUM(A1:D1) • Functions are more flexible than formulas

  25. Different Results If you delete Row 5 =SUM(C3:C5) =B3+B4+B5+B6 =SUM(C3:C6)

  26. Common Functions • SUM • AVERAGE • MIN and MAX • COUNT

  27. Relative, Absolute & Mixed Cell References

  28. Cell Reference Decisions • Is the formula entered going to be copied? • If so, which direction? • If it’s copied vertically, do you want the row references to change? If it’s copied horizontally, do you want the column references to change? • Do you want such a change to take place?

  29. Cell Reference Decisions http://www.lacoste.pamplin.vt.edu/web1504/resources/video/ss.html

  30. Cell Reference Example #1 =SUM(B2:D2) • Will you copy this function? • If so, which direction: vertical or horizontal? • If you copy vertically, Excel will automatically change all relative row references. Do you want those row references to change?

  31. Cell Reference Example #2 • Which calculation needs a mixed cell reference? • Where should the $ go?

  32. Spreadsheet Design: Accuracy • Know the order of operations. • Select the correct function or construct the correct formula. (Choose a function over a formula.) • Isolate assumptions. • Check relative and absolute cell references. • Double-check all calculations.

  33. Isolate Assumptions • Store numbers in cells • Write equations to point to cells containing numbers

  34. Isolate Assumption Example Assumption =E2+3 is incorrect =E2+H2 is correct

  35. Paste Special - Values http://www.lacoste.pamplin.vt.edu/web1504/resources/video/ss.html

More Related