mid_Questions_Answers_word

Match the following attributes of a city with the appropriate scale of measurements: Attribute (P) Average temperature (°C) of a city (Q) Name of a city (S) (R) Population density of a city Ranking of a city based on ease of Business Scale of Measurement (I) Interval (II) Ordinal (III) Nominal (IV) Ratio Which one of the following combinations is correct? A) (P)-(I), (Q)-(III), (R)-(IV), (S)-(II) B) (P)-(II), (Q)-(I), (R)-(IV), (S)-(III) c) (P)-(II), (Q)-(III), (R)-(IV), (S)-(I) D) (P)-(I), (Q)-(II), (R)-(III), (S)-(IV)

Which of the measure(s) of central location can be used for both numerical and categorical variables? Choose from: mean, median, mode, and trimmed mean.

Travel Passengers 1 405 2 410 3 420 4 415 5 412 6 420 7 424 8 433 9 438 10 440 11 446 12 451 13 455 14 464 15 466 16 474 17 476 18 482 a) Using a weighted moving average with three periods, determine the sales for day 15. Use 3, 2, and 1 for the weights of the most recent, second most recent, and third most recent periods, respectively b) Find the MAD, MSE and MAPE b) Use exponential smoothing with a smoothing constant of 0.50 to forecast the sales (Assume that last period’s forecast for period 1 is equal to actual to begin the procedure (Ft1=Yt1). Which method do you think is best? Is this an improvement over the weighted average- use MAD only

Go to https://doc.arcgis.com/en/esri-demographics/data/tapestrysegmentation.htm, and identify five segments that you would expect tofind in your zip code. Then go to www.esri.com/data/tapestry/ziplookup, and type in your zip code. Compare the segments that arefound in your zip code with your initial prediction. Are they similar ordifferent ? Discuss the extent to which you believe these are accuratedescriptions of the main segments of people who reside in your zipcode.

What is the Y coordinate if we use the center of gravity method? Please keep 3 decimals in your final answer

Tony Zamora, a real estate investor, has just moved to Clarksville and wants to learn about the local real estate market. He wants to understand, for example, the relationship between geographical segment of the city and selling price of a house, the relationship between selling price and number of bedrooms, and so on. Tony has randomly selected 24 house-for-sale listings from the Sunday newspaper and collected the data listed below. Construct a crosstabulation for the variables segment of city and number of bedrooms. a. What percentage of the houses in S have 3 bedrooms or less? b. What percentage of the houses have 3 bedroom and more than 2 bathrooms? c. What percentage of houses worth more than $395000?please demonstrate step by step on solving this problem using excel. please sponser a screenshot.  1. a. 16.67 b. 12.5 c. 2    2. a. 4.17 b. 4.17 c. 4.17    3. a. 50.00 b. 4.17 c. 8.33    4. a. 6 b. 4 c. 2

The owner of a food truck implemented a new location strategy so that they would be better positioned near a crowded office park during the lunch hour. How should they evaluate the new location strategy?

Which one of the following lists contains one measure of central location and one measure of dispersion? A. Range and Standard deviation B. Mean and Mode C.median and average D. Mode and Range

Use VLOOKUP to add the appropriate population values from j to column B

CVS chain prefers to operate one outlet in a town that has four major market segments. The number of potential customers in each segment along with the coordinates are as follows:      Market Segment  Location  Coordinates  Number of Customers     x  y    1  8  13  2000  2  10  16  800  3  4  8  1600  4  12  4  3200      Find the best location using the Center of Gravity Excel template

Please assist

Evaluating location alternatives by comparing their composite(weighted-average) scores involvesa) factor-rating analysis.b) cost–volume analysis.c) transportation model analysis.d) linear regression analysis.e) crossover analysis.

Alvin Cheah is a marketing analyst for Rockstar Travel Company. He wants to analyze the trend of international tourist arrival in Tawau by using international tourist arrival rate and flight delayed rate over the past 10 years as given in Table 2 below: (Hint: Provides your answers in two decimal points) Table 2 Year 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 Arrival (‘000) 35.5 28.0 30.3 36.0 49.5 56.0 72.4 71.0 79.3 96.0 Delayed rate 4.2 3.8 3.8 3.5 4.6 4.5 4.6 4.6 4.7 4.5   a） Propose ONE (1) forecasting model that can be used by Alvin. Why would you proposed that particularmodel?   b) Develop the forecasting model that you suggest in         (i). Briefly explain your

A manager received an analysis of several cities being considered for a new office complex. The data (10 points maximum) are as follows: Factor Business services Community services Real estate cost Construction costs Cost of living Taxes Transportation A с Thus, Location Score A A B с Thus, 17 17 17 8 6 4 3 2 8 9 B 6 6 Click here for the Excel Data File a. If the manager weights the factors equally, how would the locations stack up in terms of their composite factor rating scores? 8 7 7 19 19 19 5 7 is/are the best. C 6 7 7 6 8 b. If business services and construction costs are given weights that are double the weights of the other factors, how would the locations stack up? is/are best and 4 8 is/are least desirable.

I need it asap

help please I need it in excel

Which two measures of central location are equal when data follow a perfectly normal distribution?

1a. Use the graph below to write a linear model to approximate the population of Bangladesh. (Do not put all of the places in your equations for large numbers, instead, define your variables using “thousands” or “millions” or “billions.” show work.) b. Now, give your equation with clear variable definitions here. c. Use your model to predict the 2050 population of Bangladesh.

3. Answer the followings. a. Myanmar CP Live Stock Company Limited Shipped Sausage boxes around Myanmar. A manager wants to forecast shipments for the first four months of the next two years by using Linear equation method. The monthly forecast equation being used is: y= 402 + 3x and determine trend amounts for the first four months of the next two year: January, x=24, February, x=25; etc. b. A farm implements dealer is seeking a fourth warehouse location to complement three existing warehouses. There are three potential locations, N.C; Atlanta, Ga.; and Columbia, S.C. Charlotte would involve a fixed cost of $4,000 per month and a variable cost of $4 per unit. Atlanta would involve a fixed cost of $3,500 per month and a variable cost of $5 per unit; and Columbia would involve a fixed cost of $5,000 per month and a variable cost of $6 per unit. Use of the Charlotte location would increase system transportation costs by $19,000 per month. Atlanta by $22,000 per month, and Columbia by…

1

Alvin Cheah is a marketing analyst for Rockstar Travel Company. He wants to analyze the trend of international tourist arrival in Tawau by using international tourist arrival rate and flight delayed rate over the past 10 years as given in Table 2 below: (Hint: Provides your answers in two decimal points) (i) Propose ONE (1) forecasting model that can be used by Alvin. Why would you proposed that particular model? (ii) Develop the forecasting model that you suggest in (i). Briefly explain your model.

8. Air travel on Mountain Airlines for the past 18 weeks was: Week Passengers Week Passengers 405 10 440 410 11 446 420 12 451 415 13 455 412 14 464 6 420 15 466 7 424 16 474 8 433 17 476 9 438 18 482 a. Explain why an averaging technique would not be appropriate for forecasting. b. Use an appropriate technique to develop a forecast for the expected number of passengers for the next three weeks. 12345