Please use Excel DONT use a code . can i have screenshots and formulas to please
ID: 3829440 • Letter: P
Question
Please use Excel DONT use a code . can i have screenshots and formulas to please . thank you
the question wants to know what is the optimal arrangement for students staying 2 in a room. Who do you want to be roomate with
Problem 3 40 Points Bluefield State College is considering building on-campus dorms to house 40 students. In order to maximize student satisfaction a survey consisting of 6 questions has been developed and administered to the students who will be staying in the dorms. The questions pertain to issues such as sleep time, noise, smoking, etc. The following questions along with the potential response are reported below. 1. What time do you go to bed at night? 6pm 6, Midnight 12, 2am 14, etc. 2. What time do you get up in the morning? 6am 6, noon- 12, 2pm 14, etc 3. How neat are you? 1 Messy, 2 Moderate, 3 Very neat 4. Do you smoke? O no, 10 yes 5. How much noise do you like in your environment? 1-Little noise, 2 moderate noise, 3 -lots of noise 6. How many guests do you like having over? 1 No guests, 2 some guests, 3 lots of guests The responses for each of the 40 students are reported in table 1. Formulate the problem as an optimization model and determine what is the optimal (or near optimal) arrangement for students staying two to a room. As a hint, this problem should be formulated as a TSP and the Alldifferent constraint will be used. The objective function should consist of a total root sum of squares between 20 different sets of two roommates. The evolutionary solver in Excel will also have to be used. Be creative and try to think of how you would actually try to solve this problem and what criteria you need to use. If you were a potential roommate, who would you want to be paired with. Then extend this to the entire group.Explanation / Answer
the following information ma be helpfulto aggreagte values in excel:
Addition Formula
If you'd like to find the sum of your data data in rows A1 to A10 in your spreadsheet, you may do so by using the following formula:
=SUM(A1: A10)
If you are looking to add data in cells that are not juxtaposed, you may do so by simply typing =SUM and clicking directly on the cells you'd like to include. Make sure that the cells listed are surrounded by parenthesis (i.e. =SUM(A1, A3; C4)).
Average Formula
If you'd like to find the average of your data in rows A1 to A10 in your spreadsheet, you may do so by using the following formula:
=Average(A1: A10)
Maximum and Minimum Formula
These two formulas may be used to find the maximum and minimum numbers of data points located in rows A1 to A10 in your spreadsheet:
=Max(A1: A10)
=MIN(A1: A10)
The IF Function
The IF function may be used to apply a condition to your data. For example, if a manager would like to be notified when stock on a product reaches zero, he may use this function to program a custom notification to appear in an adjacent cell. This sort of formula would look like this:
IF(A1 <= 0; "to order", "in stock")
In this case, if the contents of cell A1 is less than or equal to zero, the words "to order" will appear in an adjacent cell. If the contents of cell A1 is greater than zero, the column will read "in stock."
A more general IF function would look like this:
= IF (condition; value "if true"; value "otherwise")
Freeze Cells in Excel
Freezing cells allows you to keep an area of your worksheet visible when you scroll to another area of the page. It's important to note that you can only freeze rows at the top of your worksheet and columns on the left side of your worksheet. You cannot freeze rows and columns in the middle.
To freeze specific tabs, head to the View tab. Here, you have the option to either Freeze Top Row or Freeze Top Column. Click either option to lock your cells in place.
If you'd like to lock multiple rows, simply select the row below the last row you'd like to freeze and then head to the View tab > Freeze Panes. Note that all rows up to and including row one will be locked.
To freeze multiple columns, highlight the column to the right of the last column that you'd like to freeze, and then head to the View tab > Freeze Panes. Note that all columns up to and including column A will be locked.