Question: Normalize the following two columns of data. Remember to normalize or standardize data you find the z-score: (x - mean)/sd. Note each column will have

Normalize the following two columns of data. Remember to normalize or standardize data you find the z-score: (x - mean)/sd. Note each column will have its own mean & standard deviation.

Age Income ($)

25 49,000

56 1,56,000

65 99,000

32 1,92,000

41 39,000

49 57,000

Use the Excel formulas =AVERAGE() and =STDEV.S. What is the mean and standard deviation of the new columns of data? Make a scatterplot on excel using the old data. Make sure to add x and y axis labels.Also, make a new scatterplot with the new data. Make sure to add x and y axis labels. Compare them.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

Exercises Chapter 2 2.1 Marginal and conditional probability: The social mobility data from Section 2.5 gives a joint probability distribution on (Y1 , Y2 )= (father's occupation, son's occupation)....

Hello, Any help on the assignment below will be appreciated. Question 1: SAMPLING (Part A) Suppose you wish to evaluate the prices ( rent asked, per week ) of 1to3bedroom rental properties. Your...

Application: Measures of Central Tendency and Variability While researchers typically show frequency distributions in a table as a way to organize large amounts of data, you may have also seen...

Table 1 . Data Description \ table [ [ Field , Description ] , [ ID , The ID of the patient is automatically assigned ] , [ Age , The recorded Age of the patient ] , [ sex , The Gender of the patient...

Use the given data " HW 2 _ Data _ B " for the following tasks: B 1 . ( 4 points ) Read and display the dataset provided. Determine the number of rows and columns present. Additionally, identify the...

Can you please help me answer the below question regarding process capability and the Taguchi loss function Question 1- Process Capability and the Taguchi Loss Function [7 marks: 2, 1, 1, 1, 2] ARGO...

The purpose of this Survey Project is to show your understanding of everything you have learned in Module 1 & Module 2. You will write a survey, collect data, find summary statistics and make graphs....

question 1 Below are four bivariate data sets and their scatter plots. (Note that all of the scatter plots are displayed with the same scale.) Each data set is made up of sample values drawn from a...

You are given two data sets ( . xlsx files ) , stored the position of cancer cells during migration experiment in two different matrices, Collagen Matrix with a high concentration of collagen and...

The following are figures on the numbers of burglaries committed in a city in random samples of six days in the spring and six days in the fall: Use the U test at the 0.01 level of significance to...

A uniform door weighs 50.0 N and is 1.0 m wide and 2.6 m high. What is the magnitude of the torque due to the door's own weight about a horizontal axis perpendicular to the door and passing through a...

Ch 0 9 Sampling Risk [ LO 9 - 5 ] Sampling Risk Read the overview below and complete the activities that follow. When performing a test of controls, auditors must be concerned with two aspects of...

A stock has an expected return of 14.2%. Given a risk-free rate of 1% and a market return of 8.8%, what is the of this stock? Enter your answer rounded to 2 DECIMAL PLACES. B= Number

(Appendices) Compare and contrast the three major ways economies can be organized. What type of economy exists in the United States? Do you think another type of economy would be better? Explain your...

(Appendices) ADJUSTING ENTRIES AND PREPARATION OF FINANCIAL STATEMENTS. Sacramento Stores unadjusted trial balance as of December 31, 19x2, appears below: The following information is also available...

(Appendices) DETERMINING UNCOLLECTIBLE ACCOUNT EXPENSE USING THE AGING METHOD. At the beginning of the year, Tennyson Auto Parts had an accounts receivable balance of $31,800 and a balance in the...