Implement your model on a spreadsheet for given information

Assignment Help Engineering Mathematics
Reference no: EM131440003

Question: Korey is a business student at State U. She has just completed a course in decision models, which had a midterm exam, a final exam, individual assignments, and class participation. She earned an 86% on the midterm, 94% on the final, 93% on the individual assignments, and 85% on participation. The benevolent instructor is allowing his students to determine their own weights for each of the four grade components-of course, with some restrictions:

• The participation weight can be no more than 15%.

• The midterm weight must be at least twice as much as the individual assignment weight.

• The final exam weight must be at least three times as much as the individual assignment weight.

• The weights of the four components must be at least 10%.

• The weights must sum to 1.0 and be nonnegative.

a. Develop a model that will yield a valid set of weights to maximize Korey's score for the course.

b. Implement your model on a spreadsheet and find a good solution using only your intuition.

c. Find an optimal solution using Solver.

Reference no: EM131440003

Questions Cloud

Anthropomorphic user interface except : The Scheneiderman book does not recommend using anthropomorphic user interface except for some special cases primarily because attributions of intelligence, autonomy, free will, etc can deceive, confuse, and mislead users.
What variable would be best to measure for the given problem : Explain the business problem or opportunity. Analyze why the business problem is important? Identify what variable would be best to measure for this problem and explain why?
Explain the concepts of gross impressions : MKA1511 ADVERTISING Identify and explain the concepts of Gross Impressions and Gross Rating Points - Tell how each is calculated. Which do YOU believe is the more important measure and why?
Calculate execution time of a program : A.) Calculate execution time of a program on a 2 GHz processor. B.) Find global CPI of the program. C.) If number of load instructions can be reduced by one-half, what is the speed up and CPI?
Implement your model on a spreadsheet for given information : Korey is a business student at State U. She has just completed a course in decision models, which had a midterm exam, a final exam, individual assignments, and class participation.
Discuss a strategy for improving memory : Identify and describe each step in the process required for remembering information in your textbook in order to do well on the exam. Discuss a strategy for improving memory and provide an example of how it could help you on the exam
Password verifier vba-scripts : Question: Password verifier VBA-scripts. Create a VBA script that simulates validation of user-passwords. The script should:
What value does program and interventions bring to agency : What value does the program and interventions bring to the agency? What ethical concerns might materialize in the implementation of the program, and how will you address them appropriately
What types of networks have you used : What types of networks have you used? What are some experiences you have had concerning the common threats listed above? How does a network topology affect data communication? Your discussion(s) should be addressed from a managers perspective as w..

Reviews

Write a Review

Engineering Mathematics Questions & Answers

  Prime number theorem

Dirichlet series

  Proof of bolzano-weierstrass to prove the intermediate value

Every convergent sequence contains either an increasing, or a decreasing subsequence.

  Antisymmetric relations

How many relations on A are both symmetric and antisymmetric?

  Distributed random variables

Daily Airlines fies from Amsterdam to London every day. The price of a ticket for this extremely popular flight route is $75. The aircraft has a passenger capacity of 150.

  Prepare a system of equations

How much money will Dave and Jane raise for charity

  Managing ashland multicomm services

This question is asking you to compare the likelihood of your getting 4 or more subscribers in a sample of 50 when the probability of a subscription has risen from 0.02 to 0.06.]  Talk about the comparison of probabilities in your explanation.

  Skew-symmetric matrices

Skew-symmetric matrices

  Type of taxes and rates in spokane wa

Describe the different type of taxes and their rates in Spokane WA.

  Stratified random sample

Suppose that in the four player game, the person who rolls the smallest number pays $5.00 to the person who rolls the largest number. Calculate each player's expected gain after one round.

  Find the probability density function

Find the probability density function.

  Develop a new linear programming for an aggregate production

Linear programming applied to Aggregate Production Planning of Flat Screen Monitor

  Discrete-time model for an economy

Discrete-time model for an economy

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd