1 / 62

Using Microsoft Excel with Exploring Marketing Research

Using Microsoft Excel with Exploring Marketing Research. By William G. Zikmund. TITLE BAR. MENU BAR. STANDARD TOOLBAR. FORMATTING TOOLBAR. FORMULA BAR. ACTIVE CELL. PASTE FUNCTION. TOOLS MENU. The Paste Function Provides Numerous Statistical Operations.

gautam
Download Presentation

Using Microsoft Excel with Exploring Marketing Research

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. Using Microsoft Excel with Exploring Marketing Research By William G. Zikmund

  2. TITLE BAR MENU BAR STANDARD TOOLBAR FORMATTING TOOLBAR FORMULA BAR ACTIVE CELL

  3. PASTE FUNCTION TOOLS MENU

  4. The Paste Function Provides Numerous Statistical Operations

  5. The Statistical Function Category

  6. Data Analysis Dialog Box • Click on “Tools” • Select “Data Analysis” • Select statistical operation • such as Histogram

  7. Functions • Functions are predefined formulas for mathematical operations • They perform calculations by using specific values, called arguments • Arguments indicate data or a range of cells • Arguments are performed, in a particular order, called the syntax.

  8. Functions • Functions are predefined formulas for mathematical operations • They perform calculations by using specific values, called arguments • Arguments are performed, in a particular order, called the syntax. • For example, the SUM function adds values or ranges of cells

  9. Easy to Use Paste Functions • AVERAGE (MEAN) • MEDIAN • MODE • SUM • STANDARD DEVIATION

  10. Functions • The syntax of a function begins with the function name • followed by an opening parenthesis • the arguments for the function • separated by commas • a closing parenthesis. • If the function starts a formula, an equal sign (=) is typed before the function name.

  11. The Equal Sign Then The Function Name And Arguments • =FUNCTION (Argument1) • =FUNCTION (Argument1,Argument2)

  12. Arguments • Typical arguments are numbers, text, arrays, and cell references. • Arguments can also be constants, formulas, or other functions.

  13. The AVERAGE Function Located in the Statistical Category

  14. Data Array • The data appear in cells A2 through 14 • A2:A14 • Sometimes written with dollars signs • $A$2:$A$14

  15. Sum, Average, and Standard Deviation • =FUNCTION (Argument1) • =SUM(A2:A9) • =AVERAGE(A2:A9) • =STDEVA(A2:A9)

  16. SUM FunctionSales Call Example

  17. AVERAGE (Mean) FunctionSales Call Example

  18. Standard Deviation FunctionSales Call Example

  19. Proportion • =COUNT • =COUNTIF • DIVIDE COUNTIF BY COUNT • =D3/D2

  20. Frequency Distributions • There are alternative ways of constructing frequency distributions • COUNTIF function • HISTOGRAM function

  21. =COUNTIF(A6:A134,1) =D4/D9*100

  22. Histogram Function • Tools -Data Analysis-Histogram • Bins

  23. The bins are the frequency categories

  24. Insert Input and Bin Ranges

  25. Text Labels Can Be Included or Excluded From Input Range

  26. The Chart Wizard

  27. The Descriptive Statistics Function

  28. SEVERAL ROWS OF DATA ARE HIDDEN

More Related