elwinpollard3715 elwinpollard3715
  • 02-08-2019
  • Computers and Technology
contestada

"A message in the Excel Solver Results dialog box telling you that the “Objective Cell values do not converge” is given when you attempt to solve a(n) _______________ problem."

Respuesta :

AbsorbingMan AbsorbingMan
  • 06-08-2019

Answer:

optimization modelling problems

Explanation:

A message in the Excel solver result dialogue box saying " Objective cell values do not converge" means that the objectives function that we have provided does not give the best result or optimum result close to the solution.

       In other words excel is finding it difficult to provider a solution anything close to the optimal value despite of many iterations because the constrain formula are not properly defined.

Answer Link

Otras preguntas

Find the y-intercept and the x-intercept of the line below.
Which line is perpendicular to a line that has a slope of One-half?
To prepare for a party, Mark buys a small bunch of balloons for $4.00 and gift bags that cost $3.85 each. He spends a total of $61.75 on the balloons and a gift
Calculate the boiling point of 3.42 m solution of ethylene glycol, C2H602, in water (Kb =0.51°C/m, the normal boiling point of water is 100°C):​
You might need: 2 Calculator AB = Round your answer to the nearest hundredth.
Is the South African Post Office a natural or artificial monopoly?​
When singing the main tune of the "Star Spangled Banner", you are singing the _______________________. a.syncopation b.harmony c.melody
Solve for x. Please help
what is climate change and wheater
Find the MODE for the data set: 47, 45, 42, 40, 42, 39, 40,38, 25, 38, 36, 39, 40, 42, 47, 40