3

Text Book Problems to Complete:

Chapter One Work: p. 19: 1.7, p. 31: 1.47 AND pp. 35 -36 reread the content in Excel Guide: List two new concepts you learned from this information on Excel OR two concepts that were a review for you in regards to Excel. (You are not required to complete any of the exercises on the page.  Just read through the examples with the perspective of what is new to you or what is a review to you.)

 

Non-text Book Problems to Complete:

Use the following information to answer the next three exercises:

You need to know what type of variable you are working with to choose the right statistical test for your data and interpret your results

Ace Hardware has a loyalty customer program. It stores information about the customer in a database. Here are the first five rows of their data base:

Transaction ID	Customer ID	Date	Item # of Purchase	Price	Coupon?	Gift	Quantity
29784320912	4J438	11/12/2021	345-23-2355	$29.95	N	N	1
26483589001	3K729	9/30/2021	983-83-2739	$9.98	N	N	3
26483589002	3K729	12/5/2021	102-65-2332	$79.95	Y	N	1
3642978936	3U034	12/5/2021	295-39-5884	$35.00	N	Y	2
36429489306	3U034	12/19/2021	183-38-2957	$16.99	N	Y	1

1. For each of the eight variables listed, decide it if is primarily quantitative or categorical?

2. For the quantitative variables, what are the units.

3. For the categorical variables, differentiate if it is ordinal or nominal.

For each description given next, identify the variable, then decide if it is quantitative or categorical. For the quantitative variables, label the units in which it was measured. If no units are given suggest some possible units in which it might be measured.

4. Yelp.com provides online restaurant reviews. For each restaurant the average cost and the percentage of customers that liked it are listed. The ratings for the food, décor, and service (all on a 20-point scale) are given.

5. Eddie Bauer is a large U.S. retailer that depends on traditional catalog sales. This company gathers data internally and tracks information on the catalogs mailed out, the number of square inches of the covers in each catalog and the amount of sales in dollar amounts in the three weeks following the excepted mail delivery date.

 

Use the following information to answer the next three questions.

Cell phones are big business. Much research is focused on customer service and understanding customer satisfaction. Over the past 12 months, Apple wants to determine where the customers who have purchased an iPhone 12 Pro Max were happy with their purchase.

6. Choose the best answer.  Be sure to include why you chose that answer: “Out of a 10-point scale, with 10 being the highest and 0 being the lowest, what is your satisfaction level with the iPhone 12 Pro Max?” are values from a:      a) discrete numerical variable      b) continuous numerical variable      c) categorical variable      d) table of random numbers

7. Choose the best answer.  Be sure to include why you chose that answer: The possible responses to the question “How many cells made by other manufactures have you used?” results in:      a) a nominal scale variable      b) an ordinal scale variable      c) an interval scale variable      d) a ratio scale variable

 

Please complete the work in a word document or Excel or a combination of both.  Please include both the text book and non-text book problems in the same document. Please upload and submit the work online through this assignment link. 

 

1.7 For each of the following variables, determine whether the variable is categorical or numerical and determine its measurement scale. If the variable is numerical, determine whether the variable is discrete or continuous.

a. Amount of money spent on electronics equipment in the past month

b. Favorite Internet source for puchases

c. Most likely time period during which Internet shopping takes place (weekday, weeknight, or weekend)

d. Number of computers owned

1.47 Results of a 2017 Computer Services, Inc. (CSI) survey of a sample of 163 bank executives reveal insights on banking priorities among financial institutions ( goo.gl/mniYMM). As financial institutions begin planning for a new year, of utmost importance is boosting profitability and identifying growth areas.

The results show that 55% of bank institutions note customer experience initiatives as an area in which spending is expected to increase. Implementing a customer relationship management (CRM) solution was ranked as the top most important omnichannel strategy to pursue with 41% of institutions citing digital banking enhancements as the greatest anticipated strategy to enhance the customer experience.

a. Describe the population of interest.

b. Describe the sample that was collected.

c. Describe a parameter of interest.

d. Describe the statistic used to estimate the parameter in (c). 

Chapter 1 Tableau Guide

TG1.1 Defining Variables

Classifying Variables by Type

Tableau infers three attributes of a column from the data that a column contains. Tableau assigns a data role to each column, initially considering any column that contains categorical data to be a Dimension and any column that contains numerical data to be a Measure. The data role of the column, in turn, affects how Tableau processes the column data as well as which choices Tableau presents in the Show Me visualization gallery (see Chapter 2).

Tableau also classifies a column as either having discrete or continuous data. Tableau uses the terms discrete and continuous in the sense that this chapter defines, except that Tableau considers all categorical data as discrete data, too. Tableau colors a column name green if the column contains continuous data and colors a column name blue if the column contains discrete data.

Tableau also determines whether the data type in the column is one of several data types. In the Data tab (shown below), Tableau displays a hashtag icon (#) before the names of columns that contain whole or decimal numbers, displays an Abc icon before the names of columns that contain alphanumeric data, and displays a calendar icon before the names of columns that contain date or date and time data. Tableau precedes a data type icon with an equals sign if the column contains the results of a calculation or represents data copied from another column. Tableau presents a Dimension or Measure name in italics if the name represents a filtered set. In the illustration below, Number of Records in the Measures list is a calculation that is also a filtered set.

To change the data role assigned to a column, right-click the column name and select Convert to Dimension or Convert to Measure from the shortcut menu. To change the assignment of discrete or continuous to a column, right-click the column name and select Convert to Continuous or Convert to Discrete from the shortcut menu. To change the assigned data type, right-click the column name and select Change Data Type and then select the appropriate choice from the shortcut menu.

1: Defining and Collecting Data

To change the data role assigned to a column, right-click the column name and select Convert to Dimension or Convert to Measure from the shortcut menu. To change the assignment of discrete or continuous to a column, right-click the column name and select Convert to Continuous or Convert to Discrete from the shortcut menu. To change the assigned data type, right-click the column name and select Change Data Type and then select the appropriate choice from the shortcut menu.

In the preceding illustration at left, Tableau has classified Region Code as a continuous (green) measure that has whole or decimal number data. Region Code is a recoding of Region that uses the numerals 1, 2, 3, and 4 to replace categorical values. Therefore, Region Code should be a Dimension that contains discrete, alphanumeric data. For the column’s shortcut menu, the three right-click selections Convert to Dimension, Convert to Discrete, and Change Data Type ➔ String would be necessary to proper reclassify Region Code. (“String” is the Tableau term for alphanumeric data.)

TG1.4 Data Cleaning

Use the Data Interpreter.

For certain types of structured data, such as Excel worksheets and Google sheets, Tableau can apply its Data Interpreter procedure to examine data for common types of error. For an Excel workbook, the interpreter will not only import corrected values but insert a series of worksheets that document its work into the workbook that is being used.

To use the interpreter, check Use Data Interpreter in the left panel of a Data Source display (shown below left). The panel display changes to Cleaned with Data Interpreter (shown below right), when the data cleaning finishes and Tableau has imported the data to be analyzed (in the illustration, the data from the Data worksheet of the Retirement Funds Excel workbook.)