Use the COUNTIF function you will not need StatTools for this part of the question.ī) Using the data in sheet Q1, create a histogram for the variable Utilities. StatTools should place each graph on a new worksheet in your file (if it does not, change the default in Utilities/Application Settings/Placement to Active Workbook.) Don’t forget that it is necessary to define the data sets within StatTools (use the option StatTools/Data Set Manager) before you may create a graph.Ī) For the data in sheet Q1, create a bar graph for the variable Location. Answer the following:Ī) Is this cross-sectional or time series data?ī) Identify the variable type and sub-type for both variables.Ĭ) If you would like examine how successful the United States has been in its efforts to “win the war against poverty” for the nation’s children, what type of graph would best answer this question? This shows the percent of children (those under 18 years of age) living below the poverty line in the United States from 1959 to 2008. Q2) Examine the data set on the worksheet Q2. Answer the following:Ī) Is this cross-sectional data or time series data?Ĭ) Ignoring the identifier variable Household, state the variable type and sub-type for each variable (categorical and ordinal or nominal, or numerical and discrete or continuous.)ĭ) If you wished to examine the distribution of the variable Monthly Payment, what would you do? List any graphs and calculations you think appropriate. A definition for each variable (unless self-explanatory) can be found in the comments section (place your cursor over any cell with a little red triangle – a comment box will pop up). This is fictional data from a survey of 500 randomly selected households. Q1) Examine the data set on the worksheet Q1. When complete, click the heading to attach your file and submit the homework in Blackboard. Perform all of your work in the Excel spreadsheet, including your text responses. To that end, the assignments will try to reinforce those particular skills by directly targeting these dimensions. your ability to interpret the results of the analysis. your ability to execute the analysis you have selected,ģ. your ability to identify the correct analytical tool to use,Ģ. During this course, you will be graded on three dimensions:ġ.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |