Question: please attach an excel document or a link to an excel google doc the question is number 2 which is the first picture on this

please attach an excel document or a link to an excel google doc

please attach an excel document or a link to an excel googlethe question is number 2 which is the first picture on this post with the attached wupartts doc the question is number 2 which is the first picture on

2. Chpt 3-4.txt is a data file for fifty people from which the first twenty were selected, as shown in Figure 3.2. Use the Text Import Wizard to bring the data into Excel and do the following: a. Insert a column at A and give every observation an ID number b. Insert a column at B and, using Date of Birth and Date of Visit, calculate an Age for each person c. Insert a column at D and, using Opinion 1, convert the words to numbers, with All of the time being 5, Some of the time being 4, and so on. Name this variable Opin- d. Insert a column at E and, using Opinion 2, convert the words to numbers, with e.Insert a column at F, name it Charges, and accumulate the costs for Procedure 1 f. Insert a column at G, name it Visit Time, and, using Arrival time and Departure time, ion 1a. Strongly agree being 5, Agree being 4, and so on. Name this variable Opinion 2a through Procedure 4 in that column calculate the number of minutes for each visit. (Hint: Format Visit time using the first format option under Time.) g. Use Edit Copy, EditPaste Special Values to fix all the calculations and save the result as an .xls file 2. Chpt 3-4.txt is a data file for fifty people from which the first twenty were selected, as shown in Figure 3.2. Use the Text Import Wizard to bring the data into Excel and do the following: a. Insert a column at A and give every observation an ID number b. Insert a column at B and, using Date of Birth and Date of Visit, calculate an Age for each person c. Insert a column at D and, using Opinion 1, convert the words to numbers, with All of the time being 5, Some of the time being 4, and so on. Name this variable Opin- d. Insert a column at E and, using Opinion 2, convert the words to numbers, with e.Insert a column at F, name it Charges, and accumulate the costs for Procedure 1 f. Insert a column at G, name it Visit Time, and, using Arrival time and Departure time, ion 1a. Strongly agree being 5, Agree being 4, and so on. Name this variable Opinion 2a through Procedure 4 in that column calculate the number of minutes for each visit. (Hint: Format Visit time using the first format option under Time.) g. Use Edit Copy, EditPaste Special Values to fix all the calculations and save the result as an .xls file

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 Databases Questions!