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
the question is number 2 which is the first picture on this post with the attached wupartts 
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
Get step-by-step solutions from verified subject matter experts
