Category: Excel

IE 8550 Fall 2024
Homework 5
(a deliverable within Module 5)
Due: Monday, October 21 at 11:59pm (EDT)
Risk Analysis Simulation
For Exercise 8 in Chapter 11, you must answer the following questions:
a) Create a simulation model of this project network. Then run the model for 10
replications. How many simulation replications are required in order to have a margin of
error on mean project duration of less than 2 days (given 90% confidence)?
b) For both 50 replications and 500 replications, simulate the project network again.
a. What is the mean duration of the project (as well as standard deviation and margin
of error)?
b. What is the duration of the project with 90% confidence?
c. How often is task H on the critical path?
d. How often is task E on the critical path?
e. How often is task G on the critical path?
You do NOT need to complete the original Exercise 11.8. You should use the project network
and activity information to build your risk analysis model in Primavera, and then answer
questions (a) and (b)
Conduct the analysis using Primavera Risk Analysis. Please assume a 7-day workweek instead
of the default five days’ workweek in Primavera Risk Analysis. To do so, you can follow one
of these two options:
1. main menu/plan/plan options/Default Task/ Calendar / change the calendar from
“standard” to “7 Day”
2. main menu/plan/calendars/workweek/ you need to check all the days here for the
“standard” calendar
Provide answers in an Excel file as well as turning in your files from Primavera Risk Analysis.
Use Canvas to submit the assignment. You will find the upload link on the Assignments page.

IE 8550 Fall 2024
Homework 5
(a deliverable within Module 5)
Due: Monday, October 21 at 11:59pm (EDT)
Risk Analysis Simulation
For Exercise 8 in Chapter 11, you must answer the following questions:
a) Create a simulation model of this project network. Then run the model for 10
replications. How many simulation replications are required in order to have a margin of
error on mean project duration of less than 2 days (given 90% confidence)?
b) For both 50 replications and 500 replications, simulate the project network again.
a. What is the mean duration of the project (as well as standard deviation and margin
of error)?
b. What is the duration of the project with 90% confidence?
c. How often is task H on the critical path?
d. How often is task E on the critical path?
e. How often is task G on the critical path?
You do NOT need to complete the original Exercise 11.8. You should use the project network
and activity information to build your risk analysis model in Primavera, and then answer
questions (a) and (b)
Conduct the analysis using Primavera Risk Analysis. Please assume a 7-day workweek instead
of the default five days’ workweek in Primavera Risk Analysis. To do so, you can follow one
of these two options:
1. main menu/plan/plan options/Default Task/ Calendar / change the calendar from
“standard” to “7 Day”
2. main menu/plan/calendars/workweek/ you need to check all the days here for the
“standard” calendar
Provide answers in an Excel file as well as turning in your files from Primavera Risk Analysis.
Use Canvas to submit the assignment. You will find the upload link on the Assignments page.

IE 8550 Fall 2024
Homework 5
(a deliverable within Module 5)
Due: Monday, October 21 at 11:59pm (EDT)
Risk Analysis Simulation
For Exercise 8 in Chapter 11, you must answer the following questions:
a) Create a simulation model of this project network. Then run the model for 10
replications. How many simulation replications are required in order to have a margin of
error on mean project duration of less than 2 days (given 90% confidence)?
b) For both 50 replications and 500 replications, simulate the project network again.
a. What is the mean duration of the project (as well as standard deviation and margin
of error)?
b. What is the duration of the project with 90% confidence?
c. How often is task H on the critical path?
d. How often is task E on the critical path?
e. How often is task G on the critical path?
You do NOT need to complete the original Exercise 11.8. You should use the project network
and activity information to build your risk analysis model in Primavera, and then answer
questions (a) and (b)
Conduct the analysis using Primavera Risk Analysis. Please assume a 7-day workweek instead
of the default five days’ workweek in Primavera Risk Analysis. To do so, you can follow one
of these two options:
1. main menu/plan/plan options/Default Task/ Calendar / change the calendar from
“standard” to “7 Day”
2. main menu/plan/calendars/workweek/ you need to check all the days here for the
“standard” calendar
Provide answers in an Excel file as well as turning in your files from Primavera Risk Analysis.
Use Canvas to submit the assignment. You will find the upload link on the Assignments page.

IE 8550 Fall 2024
Homework 5
(a deliverable within Module 5)
Due: Monday, October 21 at 11:59pm (EDT)
Risk Analysis Simulation
For Exercise 8 in Chapter 11, you must answer the following questions:
a) Create a simulation model of this project network. Then run the model for 10
replications. How many simulation replications are required in order to have a margin of
error on mean project duration of less than 2 days (given 90% confidence)?
b) For both 50 replications and 500 replications, simulate the project network again.
a. What is the mean duration of the project (as well as standard deviation and margin
of error)?
b. What is the duration of the project with 90% confidence?
c. How often is task H on the critical path?
d. How often is task E on the critical path?
e. How often is task G on the critical path?
You do NOT need to complete the original Exercise 11.8. You should use the project network
and activity information to build your risk analysis model in Primavera, and then answer
questions (a) and (b)
Conduct the analysis using Primavera Risk Analysis. Please assume a 7-day workweek instead
of the default five days’ workweek in Primavera Risk Analysis. To do so, you can follow one
of these two options:
1. main menu/plan/plan options/Default Task/ Calendar / change the calendar from
“standard” to “7 Day”
2. main menu/plan/calendars/workweek/ you need to check all the days here for the
“standard” calendar
Provide answers in an Excel file as well as turning in your files from Primavera Risk Analysis.
Use Canvas to submit the assignment. You will find the upload link on the Assignments page.

Steps to complete this project:
Mark the steps as checked when you complete them.
1. Open the start file: EX2019-MOS-Ch1 If the file opens in Protected View, click the Enable Editing button in the Message Bar at the top of the file so you can modify it.
2. The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor, and save it.
3. On the Kia data worksheet, make the following modifications:
a. Autofit column I to fit the data.
b. Modify the row height of row 1 to exactly 78.
c. Apply Freeze Panes so the first row is always visible as you scroll down the worksheet.
d. Find the cell with the underhood ID MKMXV01.6J13 and apply Bold formatting. (Hint: Verify that the top row of the worksheet is no longer selected, or the Find feature may be limited to the highlighted cells.)
4. Throughout the workbook, review headers and footers and make the following modifications:
a. From Normal view, on the Kia data worksheet, add a custom header to the center section: Kia Data
b. On the 2020 Green Cars Federal worksheet, use Layout view to delete the text in the left footer section and replace it with: Source: fueleconomy.gov
c. On the 2020 Green Cars Federal worksheet, add the sheet name to the footer center section. Hint: Do not type the sheet name in the footer. Insert a code so Excel will display the name of the current worksheet.
5. On the Kia data worksheet, make the following page and print settings modifications:
a. Using Page Break Preview view, move the page break between pages one and three to before the Stnd Description column (between columns H and I).
b. Define the print area to print only the Kia Forte data (cells A1:R7).
6. On the 2020 Green Cars Federal worksheet, make the following page and print settings modifications:
a. Change the orientation to landscape.
b. Modify the scaling so all columns will fit on one page.
c. Modify the print settings to repeat row 1 at the top of every page.
d. Set the margins to the Narrow option.
e. Split the worksheet view into two vertical panes at cell H1.
7. On the Kia data worksheet, navigate to the named range Sportage_data. When you navigate to the range, Excel will highlight the range for you. Copy the data and paste starting in cell A10 on the Summary worksheet.
8. Add hyperlinks to the Summary worksheet.
a. On the Summary worksheet, insert a hyperlink in cell A1 to navigate to cell A1 on the Kia data worksheet.
b. On the Summary worksheet, insert a hyperlink in cell A2 to navigate to the web site: https://www.fueleconomy.gov/feg/download.shtml
9. On the Summary worksheet, display formulas.
10. Import from a text file.
a. Import the tab-delimited text file SmartWay Vehicle List for MY 2020.txt to a new worksheet.
b. Rename the sheet: SmartWay
11. Import from a CSV file.
a. Import the CSV file 2022 FE Guide preliminary data.csv to a new worksheet.
b. Rename the sheet: 2022 Prelim
12. Add the Quick Print option to the Quick Access Toolbar.
13. Inspect the workbook for issues and remove all document properties and personal information.
14. Modify the workbook properties to add the keyword: fuel
15. Save and close the file.
16. Upload and save your project file.
17. Submit project for grading.
18. If directed to do so by your instructor: open the workbook file and save it in the .xls format compatible with older versions of Excel. Provide this file to your instructor for additional grading.
I’ve attached an Excel file that requires some specific modifications. Please follow the steps outlined below carefully:
Skip Steps 1 and 2: There’s no need to make any changes related to these steps. You should start directly from Step 3.
Start from Step 3: Begin the work from Step 3 as outlined in the instructions. Proceed with the necessary modifications and continue working up to Step 15.
Complete Up to Step 15: After you complete the work for Step 15, please stop. Do not go beyond Step 15.
Save the file: Once you’ve completed the work, save the file with the changes.
Send the file: Finally, please send me the updated file once you’re done. If you need any clarification or additional details regarding the steps, feel free to ask.

IMPORTANT: If you get a limit violation error, your analysis is incorrect. Look at your data carefully and think what should be included in your Data Range. Reopen the Excel file and start over.
Please adjust Data Range in the pop-up window, even if you selected the range correctly in Excel.
Please complete the problems using Excel, answer the questions asked in Word, then submit both files.
Excel worksheets contains a set of receipt data for a bakery where each row represents a different customer’s purchase. For each row, a 1 indicates they purchased that product and a 0 means they did not. In total, there are 50 different products the bakery sells, and the owner is interested in determining any association rules in the purchase patterns of their customers.
Complete an Association Rule analysis (AR analysis) on the following data using a minimum confidence percentage of 75% and a minimum support of 10.
Answer the following questions:
How many rules did Association Rule analysis found?
Pick any one of the resultant rules developed by your analysis and explain each of the columns in the output using that rule as an example.
Select the 5 rules you would recommend to the bakery owner and explain your reasoning.
Please upload the completed EXCEL workbook which shows your association rule analysis worksheets and you can type your answers to the questions in the some worksheet. In other words, your AR analysis worksheets and your answers should be in the same EXCEL file. Upload one EXCEL file to Canvas.
-answer to the first question is incorrect. Two rules is the wrong answer. You should get well over 30 rules. Because of this error, all your answers (Question 2 and 3) are also incorrect. When you first click on Association Rules in Excel Data Science add-in, it will give you a popup window. Make sure you enter the correct data range in the “Data range” field. You should exclude column A from the analysis because it is not useful for this analysis and you will select all other columns and all rows. You should manually type in the data range values in this field and make sure you anchor ($) the rows and the columns in this data field ie enter $B$1:$AY$401.
– In this same window, please make sure the radio button next to “Data in binary matrix format” is selected. THIS IS IMPORTANT. If you don’t do this, you will get incorrect results.
– Also, in the same window, please enter the values for Minimum support and minimum confidence that are given in the homework 2 problem statement.
– When you run the AR analysis in Excel, you will automatically get a new worksheet called “AR_output”. Please save this file. I need to see this in the Excel file that you email me.
-Please read the 3 questions in the homework carefully and answer the 3 questions in a new worksheet in the same Excel file, or you can email me a Word document with your answers to the 3 questions. You will need to explain the different terms such as confidence, lift ratio, etc.

IMPORTANT: If you get a limit violation error, your analysis is incorrect. Look at your data carefully and think what should be included in your Data Range. Reopen the Excel file and start over.
Please adjust Data Range in the pop-up window, even if you selected the range correctly in Excel.
Please complete the problems using Excel, answer the questions asked in Word, then submit both files.
Excel worksheets contains a set of receipt data for a bakery where each row represents a different customer’s purchase. For each row, a 1 indicates they purchased that product and a 0 means they did not. In total, there are 50 different products the bakery sells, and the owner is interested in determining any association rules in the purchase patterns of their customers.
Complete an Association Rule analysis (AR analysis) on the following data using a minimum confidence percentage of 75% and a minimum support of 10.
Answer the following questions:
How many rules did Association Rule analysis found?
Pick any one of the resultant rules developed by your analysis and explain each of the columns in the output using that rule as an example.
Select the 5 rules you would recommend to the bakery owner and explain your reasoning.
Please upload the completed EXCEL workbook which shows your association rule analysis worksheets and you can type your answers to the questions in the some worksheet. In other words, your AR analysis worksheets and your answers should be in the same EXCEL file. Upload one EXCEL file to Canvas.
-answer to the first question is incorrect. Two rules is the wrong answer. You should get well over 30 rules. Because of this error, all your answers (Question 2 and 3) are also incorrect. When you first click on Association Rules in Excel Data Science add-in, it will give you a popup window. Make sure you enter the correct data range in the “Data range” field. You should exclude column A from the analysis because it is not useful for this analysis and you will select all other columns and all rows. You should manually type in the data range values in this field and make sure you anchor ($) the rows and the columns in this data field ie enter $B$1:$AY$401.
– In this same window, please make sure the radio button next to “Data in binary matrix format” is selected. THIS IS IMPORTANT. If you don’t do this, you will get incorrect results.
– Also, in the same window, please enter the values for Minimum support and minimum confidence that are given in the homework 2 problem statement.
– When you run the AR analysis in Excel, you will automatically get a new worksheet called “AR_output”. Please save this file. I need to see this in the Excel file that you email me.
-Please read the 3 questions in the homework carefully and answer the 3 questions in a new worksheet in the same Excel file, or you can email me a Word document with your answers to the 3 questions. You will need to explain the different terms such as confidence, lift ratio, etc.

IMPORTANT: If you get a limit violation error, your analysis is incorrect. Look at your data carefully and think what should be included in your Data Range. Reopen the Excel file and start over.
Please adjust Data Range in the pop-up window, even if you selected the range correctly in Excel.
Please complete the problems using Excel, answer the questions asked in Word, then submit both files.
Excel worksheets contains a set of receipt data for a bakery where each row represents a different customer’s purchase. For each row, a 1 indicates they purchased that product and a 0 means they did not. In total, there are 50 different products the bakery sells, and the owner is interested in determining any association rules in the purchase patterns of their customers.
Complete an Association Rule analysis (AR analysis) on the following data using a minimum confidence percentage of 75% and a minimum support of 10.
Answer the following questions:
How many rules did Association Rule analysis found?
Pick any one of the resultant rules developed by your analysis and explain each of the columns in the output using that rule as an example.
Select the 5 rules you would recommend to the bakery owner and explain your reasoning.
Please upload the completed EXCEL workbook which shows your association rule analysis worksheets and you can type your answers to the questions in the some worksheet. In other words, your AR analysis worksheets and your answers should be in the same EXCEL file. Upload one EXCEL file to Canvas.
-answer to the first question is incorrect. Two rules is the wrong answer. You should get well over 30 rules. Because of this error, all your answers (Question 2 and 3) are also incorrect. When you first click on Association Rules in Excel Data Science add-in, it will give you a popup window. Make sure you enter the correct data range in the “Data range” field. You should exclude column A from the analysis because it is not useful for this analysis and you will select all other columns and all rows. You should manually type in the data range values in this field and make sure you anchor ($) the rows and the columns in this data field ie enter $B$1:$AY$401.
– In this same window, please make sure the radio button next to “Data in binary matrix format” is selected. THIS IS IMPORTANT. If you don’t do this, you will get incorrect results.
– Also, in the same window, please enter the values for Minimum support and minimum confidence that are given in the homework 2 problem statement.
– When you run the AR analysis in Excel, you will automatically get a new worksheet called “AR_output”. Please save this file. I need to see this in the Excel file that you email me.
-Please read the 3 questions in the homework carefully and answer the 3 questions in a new worksheet in the same Excel file, or you can email me a Word document with your answers to the 3 questions. You will need to explain the different terms such as confidence, lift ratio, etc.

IMPORTANT: If you get a limit violation error, your analysis is incorrect. Look at your data carefully and think what should be included in your Data Range. Reopen the Excel file and start over.
Please adjust Data Range in the pop-up window, even if you selected the range correctly in Excel.
Please complete the problems using Excel, answer the questions asked in Word, then submit both files.
Excel worksheets contains a set of receipt data for a bakery where each row represents a different customer’s purchase. For each row, a 1 indicates they purchased that product and a 0 means they did not. In total, there are 50 different products the bakery sells, and the owner is interested in determining any association rules in the purchase patterns of their customers.
Complete an Association Rule analysis (AR analysis) on the following data using a minimum confidence percentage of 75% and a minimum support of 10.
Answer the following questions:
How many rules did Association Rule analysis found?
Pick any one of the resultant rules developed by your analysis and explain each of the columns in the output using that rule as an example.
Select the 5 rules you would recommend to the bakery owner and explain your reasoning.
Please upload the completed EXCEL workbook which shows your association rule analysis worksheets and you can type your answers to the questions in the some worksheet. In other words, your AR analysis worksheets and your answers should be in the same EXCEL file. Upload one EXCEL file to Canvas.
-answer to the first question is incorrect. Two rules is the wrong answer. You should get well over 30 rules. Because of this error, all your answers (Question 2 and 3) are also incorrect. When you first click on Association Rules in Excel Data Science add-in, it will give you a popup window. Make sure you enter the correct data range in the “Data range” field. You should exclude column A from the analysis because it is not useful for this analysis and you will select all other columns and all rows. You should manually type in the data range values in this field and make sure you anchor ($) the rows and the columns in this data field ie enter $B$1:$AY$401.
– In this same window, please make sure the radio button next to “Data in binary matrix format” is selected. THIS IS IMPORTANT. If you don’t do this, you will get incorrect results.
– Also, in the same window, please enter the values for Minimum support and minimum confidence that are given in the homework 2 problem statement.
– When you run the AR analysis in Excel, you will automatically get a new worksheet called “AR_output”. Please save this file. I need to see this in the Excel file that you email me.
-Please read the 3 questions in the homework carefully and answer the 3 questions in a new worksheet in the same Excel file, or you can email me a Word document with your answers to the 3 questions. You will need to explain the different terms such as confidence, lift ratio, etc.

I CAN SUPPLY DATA SET VIA EXCEL
You are a real estate and property management business analyst in a big city. Your company’s leadership team supports building reasonably priced housing in areas that have well-performing schools with low school dropout rates (home price and dropout rate are the key factors). You wish to commission a consulting team of business and data analysts to build a full dashboard that will address the best locations for new construction projects within the five boroughs of the city based on the company’s mission and various performance metrics.
You decide to build a basic prototype model of the dashboard using the home price and dropout rate data for one borough. This prototype model will help you explain the project to your company’s leadership before you meet with the consultants who will build the full dashboard with many other predictive factors. You also want to be able to clearly report a data story about the project to the leadership team using your prototype.
To ensure you understand the data that will be included in the dashboard model, you will first need to connect your Excel data with Tableau and look at it visually.
Use the provided “D466 Task 1 Data Set” to complete this task.
Provided model data for the borough:
average three-bedroom home prices by year
average dropout % by year
Requirements
Your submission must be your original work. No more than a combined total of 30% of the submission and no more than a 10% match to any one individual source can be directly quoted or closely paraphrased from sources, even if cited correctly. The similarity report that is provided when you submit your task can be used as a guide.
You must use the rubric to direct the creation of your submission because it provides detailed criteria that will be used to evaluate your work. Each requirement below may be evaluated by more than one rubric aspect. The rubric aspect titles may contain hyperlinks to relevant portions of the course.
Tasks may not be submitted as cloud links, such as links to Google Docs, Google Slides, OneDrive, etc., unless specified in the task requirements. All other submissions must be file types that are uploaded and submitted as attachments (e.g., .docx, .pdf, .ppt).
A. Describe the two main factors—home price and dropout rate—in the scenario.
1. Explain, using data from the “D466 Task 1 Data Set,” the current state of home prices.
a. Use Tableau to create an appropriate data visualization that shows the current state of home prices.
b. Identify one design technique you used in the visualization from part A1a and explain how it addresses a common accessibility issue.
c. Identify one design technique different than the one identified in part A1b and explain how it contributes to effective representation of the information in the data set.
2. Explain, using data from the “D466 Task 1 Data Set,” how a change in school dropout rates would affect home prices.
a. Use Tableau to create an appropriate data visualization that shows how a change in school dropout rates (independent variable) would affect home prices (dependent variable).
b. Identify one design technique you used in the visualization from part A2a and explain how it addresses a common accessibility issue.
c. Identify one different design technique than the one used in part A2b and explain how it contributes to effective representation of the information in the data set.