these problems must be solved using both the graphical and solver methods. Homew

these problems must be solved using both the graphical and solver methods.
Homew

these problems must be solved using both the graphical and solver methods.
Homework instructions:
Complete the homework problems identified above in Excel. Put each problem on a separate worksheet (tab). Restate the homework problem at the top of each worksheet. Code all input cells in blue and all outputs in green. Build all formulas in the Excel worksheet so that all outputs are automatically calculated based on the input variables. Sample problems including correct formatting will be completed in the weekly (online) classroom session. To make the best use of the classroom session you should attempt all the homework problems prior to the classroom session so you can ask very specific questions to help you complete the homework. This homework will address the learning objectives of applying the proper tools to solve LP problems using the graphical method as well as demonstrating situations where special issues in LP such as infeasibility, unboundedness, redundancy, and alternative optimal solutions may apply.

Submit homework for the following Problems 7-16, 7-17, 7-18, 7-19, and 7-36. Not

Submit homework for the following Problems 7-16, 7-17, 7-18, 7-19, and 7-36. Not

Submit homework for the following Problems 7-16, 7-17, 7-18, 7-19, and 7-36. Note these problems must be solved using both the graphical and solver methods.
Homework instructions:
Complete the homework problems identified above in Excel. Put each problem on a separate worksheet (tab). Restate the homework problem at the top of each worksheet. Code all input cells in blue and all outputs in green. Build all formulas in the Excel worksheet so that all outputs are automatically calculated based on the input variables. Sample problems including correct formatting will be completed in the weekly (online) classroom session. To make the best use of the classroom session you should attempt all the homework problems prior to the classroom session so you can ask very specific questions to help you complete the homework. This homework will address the learning objectives of applying the proper tools to solve LP problems using the graphical method as well as demonstrating situations where special issues in LP such as infeasibility, unboundedness, redundancy, and alternative optimal solutions may apply.

Scenario Smart businesses in all industries use data to provide an intuitive ana

Scenario
Smart businesses in all industries use data to provide an intuitive ana

Scenario
Smart businesses in all industries use data to provide an intuitive analysis of how they can get a competitive advantage. The real estate industry heavily uses linear regression to estimate home prices, as cost of housing is currently the largest expense for most families. Additionally, in order to help new homeowners and home sellers with important decisions, real estate professionals need to go beyond showing property inventory. They need to be well versed in the relationship between price, square footage, build year, location, and so many other factors that can help predict the business environment and provide the best advice to their clients.
Prompt
You have been recently hired as a junior analyst by D.M. Pan Real Estate Company. The sales team has tasked you with preparing a report that examines the relationship between the selling price of properties and their size in square feet. You have been provided with a Real Estate Data Spreadsheet spreadsheet that includes properties sold nationwide in recent years. The team has asked you to select a region, complete an initial analysis, and provide the report to the team.
Note: In the report you prepare for the sales team, the response variable (y) should be the listing price and the predictor variable (x) should be the square feet.
Specifically you must address the following rubric criteria, using the Module Two Assignment Template:
Generate a Representative Sample of the DataSelect a region and generate a simple random sample of 30 from the data.
Report the mean, median, and standard deviation of the listing price and the square foot variables.
Analyze Your SampleDiscuss how the regional sample created is or is not reflective of the national market.Compare and contrast your sample with the population using the National Summary Statistics and Graphs Real Estate Data PDF document.
Explain how you have made sure that the sample is random.Explain your methods to get a truly random sample.
Generate ScatterplotCreate a scatterplot of the x and y variables noted above. Include a trend line and the regression equation. Label the axes.
Observe patternsAnswer the following questions based on the scatterplot:Define x and y. Which variable is useful for making predictions?
Is there an association between x and y? Describe the association you see in the scatter plot.
What do you see as the shape (linear or nonlinear)?
If you had a 1,800 square foot house, based on the regression equation in the graph, what price would you choose to list at?
Do you see any potential outliers in the scatterplot?Why do you think the outliers appeared in the scatterplot you generated?
What do they represent?

Create a large graph model of the map for a mail carrier to deliver mail to all

Create a large graph model of the map for a mail carrier to deliver mail to all

Create a large graph model of the map for a mail carrier to deliver mail to all the residences in the neighborhood. This means the intersections will be vertices and the streets will be edges. You will need to put double edges for any streets where there are residences on both sides. However, if there is a park or school on one side then you would use a single edge. See mail carrier graph examples from class videos if this does not seem clear. Your graph model should take up most of an 8 ½ by 11 page and must not be drawn over the map you chose. Some students have used a technique of laying paper over a printout of the map or over their computer screen and drawing the graph with the map as a guide underneath. Please use pencil or black ink for the graph. Or if you want to go completely digital, you may draw your graph using a digital drawing tool. Just be sure the graph is your own work, is in pdf format for viewing, and fills the page.
Answers to three common questions when creating your graph model:
If there is a little piece of street that sticks out and is cut off by my circle around the map, you do not need to include it.
For courts, you can use a double edge or a loop – both are going to work out the same in the end. In my mini sample on the next page, I used double edges.
You can assume there are houses on both sides if the background is grey. Don’t worry about what direction houses are facing. I don’t want it to get too complicated.
3. Highlight any odd vertices on your graph using a highlighter or colored pencil. If you don’t have any odd vertices, write this down under the map.
4. Next add duplicate edges as needed using a different bright color such as red or using dashes to indicate that they are edges that were added after checking for odd vertices to the graph model to EULERIZE the graph. (This will create a graph with all even vertices.) Remember your goal is to add as few duplicate edges as possible so the mail carrier does not have to walk unnecessarily far but you cannot add edges where there were no streets before.
5. Show an Euler Circuit for the mail carrier, indicating where the start and end of the route is, numbering the edges and showing arrows for direction of travel.