New representatives for the John Ford Metal and Wheel Company attend a brief training program before being assigned to a regional office. At the end of such a program, each representative was ranked with respect to future sales potential. At the end of the first sales year, their rankings were paired with their annual sales: 3. 5. 6. 7. 8. 9. 10. ܪ a. b. C. Representative Kitchen Bond Gross Arbuckle Greene Arden Crane Arthur Keene Knopf Annual Sales ($000) 319 150 175 460 348 300 280 200 190 300 Ranking in Training Program 4 9 6 1 3 10 84278 Compute Spearman's rank correlation coefficient. Interpret. Do a hypothesis test at the .01 level of significance.

A company's sales in Seattle were $390,000 in 2012, while their sales in Portland were $270,000 for the same year. Complete the following statements:a. Seattle's sales were  % larger than Portland's.b. Portland sales were  % smaller than Seattle's.c. Portland sales were  % of Seattle's.Give answers accurate to at least one decimal place.

Use the following price information for selected items for 2010 and 2018. Production figures for those two periods are also given.

Please fill in the following table according Margaret's budget. Note: Round your answer to the nearest whole dollar or percent. Use the $ sign or the % sign. Examples: $2,356, 17% In the image.

The average annual cost of living in Illinois, California, and Oregon are displayed in the table below:   State Average Annual Cost of Living Illinois $58,000 California $70,000 Oregon $64,000 Suppose you are earning a salary of $65,000 per year in Illinois. Your employer asks you to transfer to the California office. Based on the average annual cost of living, what is the lowest possible salary you will accept? Round your answer to the nearest whole dollar. Explain your reasons.

Please show steps in Excel. The 32 teams in the National Football League (NFL) are worth, on average, $1.17 billion, 5% more than last year. The datafile NFLTEAMVALUE shows the annual revenue ($millions) and the estimated team value ($ millions) for the 32 NFL teams (Forbes website, February 28, 2014). a.Develop a scatter diagram with Revenue on the horizontal axis and Value on the vertical axis. Does there appear that there is any relationship between the two variables? b. What is the sample correlation coefficient? What can you say about the strength of the relationship between Revenue and Value? Team Revenue ($ millions) Current Value ($ millions) Arizona Cardinals 253 961 Atlanta Falcons 252 933 Baltimore Ravens 292 1,227 Buffalo Bills 256 870 Carolina Panthers 271 1,057 Chicago Bears 298 1,252 Cincinnati Bengals 250 924 Cleveland Browns 264 1,005 Dallas Cowboys 539 2,300 Denver Broncos 283 1,161 Detroit Lions 248 900 Green Bay Packers 282 1,183 Houston…

The Sea Wharf Restaurant would like to determine the best way to allocate a monthly advertising budget of $1,000 between newspaper advertising and radio advertising. Management decided that at least 25% of the budget must be spent on each type of media and that the amount of money spent on local newspaper advertising must be at least two and a half times the amount spent on radio advertising. A marketing consultant developed an index that measures audience exposure per dollar of advertising on a scale from 0 to 100, with higher values implying greater audience exposure. If the value of the index for local newspaper advertising is 50 and the value of the index for spot radio advertising is 80, how should the restaurant allocate its advertising budget to maximize the value of total audience exposure? (a) Formulate a linear programming model that can be used to determine how the restaurant should allocate its advertising budget in order to maximize the value of total audience exposure. If…