business modeling
1- the file P02_01.xlsx indicates the gender and nationality of the MBA incoming class in two successive years at the Kelly school of business at Indiana university.
A- For each year, create tables of counts of gender and of nationality. Than create clumn charts of these counts. Do they indicate any noticeable change in the composition of the two classes?
B- Repeat part a for nationality, but recode this variable so that all nationalities that have counts of 1 or 2 are classified as other.
6- The file P02_06.xlsx lists the average time (in minutes) it takes citizens of 379 metropolitan areas to travel to work and back home each day.
A- Create a histogram of the daily commute times.
B- Find the most representative average daily commute time across this distribution.
C- Find a useful measure of the variability of these average commute times around the mean.
D- The empirical rule for standard deviations indicates that approximately 95% of these average travel times will fall between which two values? For this particular data set, is this empirical rule at least approximately correct?
20- The file P02_21.xlsx consumer confidence lndex (CCI) attempts to measure people's feelings about general business conditions, employment opportunities, and their own income prospects. Monthly average values of the CCI are listed in the file P02_20.xlsx.
A- Create a time series graph of the CCI values.
B- Have U.S consumers become more or less confident through time?
C- How would you explain recent variations in the overall trend of the CCI?
33- The file P02_03.xlsx contains data from a survey of 399 people regarding an environmental policy. Use filters for each of the following.
A- Identify all respondents who female, middle age, and have two children. What is the average salary of these respondents?
B- Identify all the respondents who are elderly and strongly disagree with the environmental policy. What is the average salary of these
A- For each year, create tables of counts of gender and of nationality. Than create clumn charts of these counts. Do they indicate any noticeable change in the composition of the two classes?
B- Repeat part a for nationality, but recode this variable so that all nationalities that have counts of 1 or 2 are classified as other.
6- The file P02_06.xlsx lists the average time (in minutes) it takes citizens of 379 metropolitan areas to travel to work and back home each day.
A- Create a histogram of the daily commute times.
B- Find the most representative average daily commute time across this distribution.
C- Find a useful measure of the variability of these average commute times around the mean.
D- The empirical rule for standard deviations indicates that approximately 95% of these average travel times will fall between which two values? For this particular data set, is this empirical rule at least approximately correct?
20- The file P02_21.xlsx consumer confidence lndex (CCI) attempts to measure people's feelings about general business conditions, employment opportunities, and their own income prospects. Monthly average values of the CCI are listed in the file P02_20.xlsx.
A- Create a time series graph of the CCI values.
B- Have U.S consumers become more or less confident through time?
C- How would you explain recent variations in the overall trend of the CCI?
33- The file P02_03.xlsx contains data from a survey of 399 people regarding an environmental policy. Use filters for each of the following.
A- Identify all respondents who female, middle age, and have two children. What is the average salary of these respondents?
B- Identify all the respondents who are elderly and strongly disagree with the environmental policy. What is the average salary of these