BUSI 402 Ch 7

BUSI 402 Ch 7 - Chapter 7: Organizing Data for Effective...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Chapter 7: Organizing Data for Effective Analysis I. Level 1: Importing and Structuring Text Data in Excel Worksheets a. String – refers to a meaningful sequence of characters b. Comma-delimited file/ comma-separated values (CSV) – a common way of storing data so that it is usable in other programs b.i. Separates the values in each record with commas c. Concatenate – link together. Combines the values in a range of cells into one text item in a new cell c.i. CONCATENATE(text1, text2, …) c.ii. i.e. inserting commas: =CONCATENATE(A1, “,” , A2, “,”, A3) d. RIGHT function – returns the last character of characters in a text string, based on the number of characters specified d.i. =RIGHT(text, num_chars) d.i.1. Text – the text string or cell reference that contains the characters you want to extract d.i.2. Num_chars – specifies the number of characters that you want the RIGHT function to extract e. LEFT function – extracts characters from the beginning or left side of a text string f. TRIM function – removes all spaces in a text string except for the single spaces between words f.i. =TRIM(text) f.ii. Useful when importing data from another data source in which the data might contain spaces at the end of values f.iii. i.e. =CONCATENATE(TRIM(A1), “,” ,TRIM( A2), “,”,TRIM( A3)) g. FIND function – returns the starting position of one text value within another text value g.i. Case sensitive, so searching for a D brings different results than searching for a d g.ii. =FIND(find_text, within_text, start_num) g.ii.1. Find_text – the text you want to find g.ii.2. Within_text – the text containing the number you want to find g.ii.3. Start_num – if omitted assumed to be 1 h. SEARCH function – does the same thing as find, but isn’t case sensitive i. Common Functions that Manipulate Data: i.i. CLEAN(text) – removes all nonprintable characters from a text string. Useful when importing data from an external data source i.ii. CONCATENATE i.iii. DOLLAR(number, decimals) – converts a number to text in currency format with a dollar sign and the specified number of decimal places i.iv. EXACT(text1, text2) – compares the 2 text strings to determine if they are identical (case sensitive) i.v. FIND i.vi. FIXED(number, decimals, no_commas) – rounds a number to a specified number of decimals and returns the number as text with commas and a period i.vii. LEFT i.viii. LEN(text) – returns the number of characters in a text string i.ix. LOWER(text) – converts uppercase letters in a text string to lowercase
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
i.x. MID(text, start_num, num_chars) – returns a specific number of characters in a text string using start_num as the starting point i.xi. PROPER(text) – capitalizes the first letter in each word in a text string and converts all other letters to lowercase. Very useful when data has been
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 02/22/2012 for the course BUSI 402 taught by Professor Staff during the Fall '10 term at UNC.

Page1 / 5

BUSI 402 Ch 7 - Chapter 7: Organizing Data for Effective...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online