Can anyone please explain step by step how to solve this by excel solver cause the solver won't accept the binary word

A group of college students is planning a camping trip during the upcoming break. The group must hike several miles through the woods to get to the campsite, and anything that is needed on this trip must be packed in a knapsack and carried to the campsite. On particular student, Tina Shawl, has identified eight items that she would like to take on the trip, but the combined weight is too great to take all of them. She has decided to rate the utility of each item on a scale of 1 to 100, with 100 being the most beneficial. The item weights in pounds and their utility values are given below.

Item    1    2 3 4    5    6 7 8

Weight 8    1 7    6 3 12 5 14

Utility 80    20 50    55    50 75 30    70

Recognizing that the hike to the campsite is a long one, a limit of 35 pounds has been set as the maximum total weight of the items to be carried.

a) Formulate this as a 0-1 programming problem to maximize the total utility of the items carried.Solve this knapsack problem using a computer.

b) Suppose item number 3 is an extra battery pack, which may be used with several of the other items.Tina has decided that she will only take item number 5, a CD player, if she also takes item number 3.On the other hand, if she takes item number 3, she may or may not take item number 5.Modify this problem to reflect this and solve the new problem.

Suppose that a bicyclist is traveling at an energetic 20 mph on a flat road, and the combination of rolling resistance and air drag is 10 pounds. (48 pts, 8 pts each part) a. What is the rate at which the bicyclist is doing useful work at this speed, in watts and horsepower? b. Measurements indicate that this performance requires conversion of food energy at a rate of 8 kcal/min. What is the first-law efficiency of the cyclist as a machine in converting energy to work at 20 mph? Assume that in a sedentary state, the rate of energy consumed by the cyclist’s body is 1.5 kcal/min. c. What is the bicyclist’s “miles per gallon” equivalent if the energy in the extra food consumed to power the bicycle is equated to the energy in gasoline? d. If the needed energy is obtained from energy bars containing 200 Calories and costing $1.50 each, what is the bicyclist’s fuel cost in cents per mile? What is the fuel cost in cents per mile for a car that gets 20 mpg using $3 per gallon gasoline? e. What are the CO2 emissions per mile for the bicyclist and the car? Consider only what is being emitted as they proceed. Do not include lifecycle considerations, and for the bicyclist only include the CO2 associated with propulsion. For the bicyclist, assume the energy bar consists of carbohydrates with a simplified molecular formula of CH2O and an energy content of 4 kcal/g. For the car, assume the gasoline consists of entirely of iso-octane, C8H18, with a specific gravity of 0.7 and an energy content of 45 MJ/kg. f. Without doing a calculation, name at least three elements of a lifecycle CO2 analysis that would change the emissions per mile calculation above, and whether they would tend to increase or decrease the value for each of the transportation modes.

Hudson Group is a one of the largest and most recognizable travel retailers in North America. we own and manage over 1,000 duty-paid and duty-free stores in 89 locations, including airports, commuter terminals, hotels and some of the most visited landmarks and tourist destinations in the world.
In 2019 we initiated the Hudson Next Project, one of the key pillars being the completion of design and implementation of four new brands within the current Business Operating Model.
These brands include: Speciality stores, Newsstands, Book stores & Brook stone stores
The new Specitity stores will be based out of the LAX airport. They will cost approximately $19 million to contruct and will require approximately 50 employees to operate. The Newstands, located in Newark, New Jersey, will be based out of the airport - less than 15 miles outside of New York City, will cost $6.5 million to construct and 20 employees to operate. The bookstores, located in Houston, will require⁶ $8 million to construct and 15 employees to operate. Located in the suburbs of Pittsburgh, Pennsylvania, the new Brookstones stores will cost $12 million to construct and 50 employees to operate across all stores.
Hudson Group will pledge 75.5 million in new construction and hire no more than 260 employees. Annually, Specialty stores are a 9.5 million operation, Newstands are a $2.4 million operation, bookstores are a 1.2 million operation and the new Brookstones stores net 3.3 million in volume and growing.
If Hudson Group wasnts to maximize it’s annual revenue, how many of each for brands should they build?

***PLEASE SHOW FORMULAS AND ANSWERS PROBLEM IN EXCEL FORMAT USING SCREENSHOTS. THANK YOU

Variable Costing Income Statement for a Service Company

East Coast Railroad Company transports commodities among three routes (city-pairs): Atlanta/Baltimore, Baltimore/Pittsburgh, and Pittsburgh/Atlanta. Significant costs, their cost behavior, and activity rates for April are as follows:

Operating statistics from the management information system reveal the following for April:

a. Prepare a contribution margin by route report for East Coast Railroad Company for the month of April. Compute the contribution margin ratio. Rounded to one decimal place. If required, use the minus sign to indicate a negative contribution margin.

The following table shows age distribution and location of a random sample of 166 buffalo in a national park.

Use a chi-square test to determine if age distribution and location are independent at the 0.05 level of significance.

(a) What is the level of significance?


State the null and alternate hypotheses.

H₀: Age distribution and location are independent.
H₁: Age distribution and location are independent.H₀: Age distribution and location are independent.
H₁: Age distribution and location are not independent.    H₀: Age distribution and location are not independent.
H₁: Age distribution and location are independent.H₀: Age distribution and location are not independent.
H₁: Age distribution and location are not independent.

(b) Find the value of the chi-square statistic for the sample. (Round the expected frequencies to at least three decimal places. Round the test statistic to three decimal places.)


Are all the expected frequencies greater than 5?

YesNo    

What sampling distribution will you use?

binomialStudent's t    chi-squareuniformnormal

What are the degrees of freedom?


(c) Find or estimate the P-value of the sample test statistic. (Round your answer to three decimal places.)

p-value > 0.1000.050 < p-value < 0.100    0.025 < p-value < 0.0500.010 < p-value < 0.0250.005 < p-value < 0.010p-value < 0.005

(d) Based on your answers in parts (a) to (c), will you reject or fail to reject the null hypothesis of independence?

Since the P-value > ?, we fail to reject the null hypothesis.Since the P-value > ?, we reject the null hypothesis.    Since the P-value ? ?, we reject the null hypothesis.Since the P-value ? ?, we fail to reject the null hypothesis.

(e) Interpret your conclusion in the context of the application.

At the 5% level of significance, there is sufficient evidence to conclude that age distribution and location are not independent.At the 5% level of significance, there is insufficient evidence to conclude that age distribution and location are not independent.   

3.

a. According to a study, 75% of adults ages 18-29 years had broadband Internet access at home in 2011. A researcher wanted to estimate the proportion of undergraduate college students (18-23 years) with access, so she randomly sampled 181 undergraduates and found that 158 had access. Estimate the true proportion with 90% confidence. Round your answers to three decimal places. ___ < p < ____

b. it has been reported that 20.4% of incoming freshmen indicate that they will major in business or a related field. a random sample of 424 incoming college freshmen were asked their preference, and 81 replied that they were considering business as a major Estimate the true proportion of freshman business majors with 97% confidence. a survey of 50 students in grades 4 through 12 found 64% have classroom Wi-Fi access. Find the 90% confidence interval of the population proportion.

____ < p < ____

c. using table g, find the values for x^2 left and x^2 right of the following. when a = 0.02 and n =11

X^2 left =_____

x^2 right= _____

d. Find the 98% confidence interval for the variance and standard deviation of the ages of seniors at Oak Park college if a sample of 23 students has a standard deviation of 2.7 years. Assume the variable is normally distributed. Use the chi-square distribution table to find any chi-square values to three decimal places. ROUND TO ONE DECIMAL PLACE FOR FINAL ANSWER

____ < o^2 < ______

____ < o^2 < ______

e. A random sample of stock prices per share (in dollars) is shown. Find the 98% confidence interval for the variance and standard deviation for the prices. Assume the variable is normally distributed. ROUND TO THREE DECIMAL PLACES

46.12 10.87 40.25 60.50

28.00 28.25 6.94 45.12

13.62 53.81

_______ < o^2 < ______

______ < o < ______

f. estimate the variance in mean mathematics SAT scores by state, using the randomly selected scores listed below. Estimate the 95% confidence. 502 211 209 499 565 469 543 572 550 515

___ < o^2 < _____

The following table shows age distribution and location of a random sample of 166 buffalo in a national park.

Use a chi-square test to determine if age distribution and location are independent at the 0.05 level of significance.

(a) What is the level of significance?


State the null and alternate hypotheses.

H₀: Age distribution and location are not independent.
H₁: Age distribution and location are not independent.H₀: Age distribution and location are independent.
H₁: Age distribution and location are independent.    H₀: Age distribution and location are independent.
H₁: Age distribution and location are not independent.H₀: Age distribution and location are not independent.
H₁: Age distribution and location are independent.

(b) Find the value of the chi-square statistic for the sample. (Round the expected frequencies to at least three decimal places. Round the test statistic to three decimal places.)


Are all the expected frequencies greater than 5?

YesNo    

What sampling distribution will you use?

normaluniform    binomialchi-squareStudent's t

What are the degrees of freedom?


(c) Find or estimate the P-value of the sample test statistic. (Round your answer to three decimal places.)

p-value > 0.1000.050 < p-value < 0.100    0.025 < p-value < 0.0500.010 < p-value < 0.0250.005 < p-value < 0.010p-value < 0.005

(d) Based on your answers in parts (a) to (c), will you reject or fail to reject the null hypothesis of independence?

Since the P-value > α, we fail to reject the null hypothesis.Since the P-value > α, we reject the null hypothesis.    Since the P-value ≤ α, we reject the null hypothesis.Since the P-value ≤ α, we fail to reject the null hypothesis.

(e) Interpret your conclusion in the context of the application.

At the 5% level of significance, there is sufficient evidence to conclude that age distribution and location are not independent.At the 5% level of significance, there is insufficient evidence to conclude that age distribution and location are not independent.

The following table shows age distribution and location of a random sample of 166 buffalo in a national park.

Use a chi-square test to determine if age distribution and location are independent at the 0.05 level of significance.

(a) What is the level of significance?


State the null and alternate hypotheses.

H₀: Age distribution and location are independent.
H₁: Age distribution and location are independent.H₀: Age distribution and location are independent.
H₁: Age distribution and location are not independent.     H₀: Age distribution and location are not independent.
H₁: Age distribution and location are not independent.H₀: Age distribution and location are not independent.
H₁: Age distribution and location are independent.

(b) Find the value of the chi-square statistic for the sample. (Round the expected frequencies to at least three decimal places. Round the test statistic to three decimal places.)


Are all the expected frequencies greater than 5?

YesNo     

What sampling distribution will you use?

chi-squarenormal     binomialuniformStudent's t

What are the degrees of freedom?


(c) Find or estimate the P-value of the sample test statistic. (Round your answer to three decimal places.)

p-value > 0.1000.050 < p-value < 0.100     0.025 < p-value < 0.0500.010 < p-value < 0.0250.005 < p-value < 0.010p-value < 0.005

(d) Based on your answers in parts (a) to (c), will you reject or fail to reject the null hypothesis of independence?

Since the P-value > α, we fail to reject the null hypothesis.Since the P-value > α, we reject the null hypothesis.     Since the P-value ≤ α, we reject the null hypothesis.Since the P-value ≤ α, we fail to reject the null hypothesis.

(e) Interpret your conclusion in the context of the application.

At the 5% level of significance, there is sufficient evidence to conclude that age distribution and location are not independent.

At the 5% level of significance, there is insufficient evidence to conclude that age distribution and location are not independent.

If you have a chance please answer as many as possible, thank you and I really appreciate your help experts!

Question 1 2 pts

A consumer analyst reports that the mean life of a certain type of alkaline battery is no more than 63 months. Write the null and alternative hypotheses and note which is the claim.

Flag this Question

Question 2 2 pts

A business claims that the mean time that customers wait for service is at most 9.2 minutes. Write the null and alternative hypotheses and note which is the claim.

Flag this Question

Question 3 2 pts

An amusement park claims that the average daily attendance is at least 12,000. Write the null and alternative hypotheses and note which is the claim.

Flag this Question

Question 4 2 pts

A transportation organization claims that the mean travel time between two destinations is about 12 minutes. Write the null and alternative hypotheses and note which is the claim.

Flag this Question

Question 5 2 pts

If the null hypothesis is not rejected when it is false, this is called __________.