You are a Financial Advisor and have been asked to perform the following task:

Using provided real world data determine the budgetary annual expenditure your client should anticipate, assuming your client has the following social/economic family profile.

Profile:

Family Income $97,000.00

Marital Status Single

Family Size Four (4)

Age Fifty Three (53)

Step #2: Review the provided sample data set provided.

The random data to be used in this study has been downloaded and is provided as an attachment in this folder. Detailed information on the sample and variables is included with the attachment (data set file). Please carefully review this information to familiarize yourself with the data

Note: This data set will be used for all of the written assignments.

Step 3: Complete the following Table

Do not enter data here. Enter data in the Attachment for submitting Assignment 1

Variable	Categorize*	Minimum	Maximum	Mean	Shape **	Outlies***
Income
Family Size
Age

* Abbreviations: Qual. for Qualitative data (categorical), Quant for Quantitative data

** Left, Right, Symmetrical (Sym.)

*** Identify outliers by Id number or 0

Step 4: Graph for the following variables

Food vs Age

Food vs Marital Status

Food vs Income

Describe at least one important characteristic observed from each graph.

Step 5 Based upon the data provided: Provide 7 or more subjects that best represent your clients social/economic lifestyle. If one or more of the 7 recommended subjects is a push, identify the outlier or outliers with a short concise explanation as to why.

Step 6 What is your estimate of the mean and standard deviation of the cost of food for your client based upon the 7 representative subjects?

Step 7 Explain in bullet form, in a clear and orderly procedure: the method used (in step format) for determining your recommended list of subjects.

SE- Unique ID # SE-Marital Status SE- Income SE-Age USD-Annual HeadHousehold FamilySize Expenditures USD- Food USD USD- Housing Transport 1 35 4 6900 145 2 1 6937 97469 97912 96697 96653 96664 49 49 3 4 2 6971 6943 152 136 124 51 4 5 53 3 7051 168 54929 55704 56453 56488 55558 55963 55247 55932 56124 56051 4 6 7 146 52 59 7040 6948 18514 18619 18520 18838 18502 18435 18483 18701 18676 18484 18312 2 133 95744 94929 96928 97681 96244 8 43 3 6953 145 9 53 4 7097 134 10 4 7073 141 56 44 11 2 55321 6982 153 120 12. 39 2 13 2 57 59 7051 6822 7179 7036 135 123 14 56440 56097 56515 56393 82299 2 18376 18334 18648 18389 23063 23155 15 40 Not Married Not Married Not Married Not Married Not Married Not Married Not Married Not Married Not Married Not Married Not Married Not Married Not Married Not Married Not Married Married Married Married Married Married Married Married Married Married Married Married Married Married Married Married 3 114 16 57 4 132 10983 9395 54 3 151 17 18 19 50 4 9101 211 46 1 168 58 20 21 96886 96727 96690 96572 98717 106292 95801 95385 95865 109312 114051 110651 107338 101829 102244 113558 100947 107369 106894 97769 37 42 6 5 167 58 4 113 67 2 47 73798 74110 74789 80801 84486 83766 83651 82385 74687 79861 73973 83441 81585 73950 4 22 23 24 25 26 27 28 121 45 34 22847 22621 25392 25728 22899 21893 22409 27964 25006 26783 23174 22396 22867 9321 10564 10820 11226 11710 10821 8735 10346 8455 11724 11360 9035 4 60 31 35 66 5 4 2 5 141 36 82 162 202 29 51 30 47 5 SE- Unique ID # SE-Marital Status SE- Income SE-Age USD-Annual HeadHousehold FamilySize Expenditures USD- Food USD USD- Housing Transport 1 35 4 6900 145 2 1 6937 97469 97912 96697 96653 96664 49 49 3 4 2 6971 6943 152 136 124 51 4 5 53 3 7051 168 54929 55704 56453 56488 55558 55963 55247 55932 56124 56051 4 6 7 146 52 59 7040 6948 18514 18619 18520 18838 18502 18435 18483 18701 18676 18484 18312 2 133 95744 94929 96928 97681 96244 8 43 3 6953 145 9 53 4 7097 134 10 4 7073 141 56 44 11 2 55321 6982 153 120 12. 39 2 13 2 57 59 7051 6822 7179 7036 135 123 14 56440 56097 56515 56393 82299 2 18376 18334 18648 18389 23063 23155 15 40 Not Married Not Married Not Married Not Married Not Married Not Married Not Married Not Married Not Married Not Married Not Married Not Married Not Married Not Married Not Married Married Married Married Married Married Married Married Married Married Married Married Married Married Married Married 3 114 16 57 4 132 10983 9395 54 3 151 17 18 19 50 4 9101 211 46 1 168 58 20 21 96886 96727 96690 96572 98717 106292 95801 95385 95865 109312 114051 110651 107338 101829 102244 113558 100947 107369 106894 97769 37 42 6 5 167 58 4 113 67 2 47 73798 74110 74789 80801 84486 83766 83651 82385 74687 79861 73973 83441 81585 73950 4 22 23 24 25 26 27 28 121 45 34 22847 22621 25392 25728 22899 21893 22409 27964 25006 26783 23174 22396 22867 9321 10564 10820 11226 11710 10821 8735 10346 8455 11724 11360 9035 4 60 31 35 66 5 4 2 5 141 36 82 162 202 29 51 30 47 5