You have been retained by “Expressive Espresso” to help them decide where to build their next Expressive Espresso coffee house. You are therefore interested in what affects the total number of sales per day. You thus look at fifty of the existing Expressive Espresso shops and gather information on each of them. You think average daily sales (in dollars) could be affected by location, so you decide to gather information on the zip code for each Expressive Espresso shop, but you also think that the number of cars that drive past each day along with the modal education (highest degree earned) of the people in the area are also important. You collect all the data and do your experiment. a. What is the sample in the above experiment? How does it differ from the population?

The worksheet shown in the figure below contains two years of sales that will be used to create a PivotChart. The goal is to create a column chart that shows the total sales dollars by year for each month. Given this goal, what would be the best chart area to place the Year field? 1 2 3 4 3 6 7 . 9 10 11 12 13 14 15 Year Month 2017 April 2018 April 2017 August 2018 August 2017 December 2018 December 2017 February 2018 February 2017 January 2018 January 2017 July 2018 July 2017 June 2018 June VALUES O LEGEND AXIS FILTERS Total Sales Dollars $ 50,970.00 $ 48,400.00 $ 52,470.00 $ 50,700.00 $112,425.00 $120,000.00 $ 56,205.00 $ 56,850.00 $ 59,940,00 $ 62,950.00 $19.980.00 $ 18,500.00 $ 22.485.00 $ 21,000.00

I need help with this question. writting code  Question:  The management also wants you to run descriptive statistics for the relative skill of the Bulls from 1996-1998. Calculate descriptive statistics including the mean, median, variance, and standard deviation for the relative skill of the assigned team.   The dataframe for the assigned team is called assigned_team_df. The variable 'elo_n' respresent the relative skill of the teams. Your statistics should be rounded to two decimal places.

Do you run your own business or have access to business data? If yes let’s brainstorm about data you would want to collect. Store daily sales in a table like below. Observation Date Sales In Dollars 1 6/30/2021 2512.30 2 7/1/2021 2945.12   Etc. This works if you are selling a single product, or if you want to aggregate all products into one. Aggregation is useful in analysis, but personally I believe it is better to gather data at its lowest form and then aggregate. Suppose you are doing analysis for a simple bakery. By simple I mean a small menu of items, see the table below. Product Acronym Large Loaf (Swiss bread 2 lb. loaf) LL Small Loaf (Swiss bread 1 lb. loaf) SL Banana Bread BB Banana Nut Bread BNB Oatmeal raisin Cookies (1 dozen) OR Chocolate Chip Cookies (1 dozen) CCC Cinnamon Roll (each) CR   Relevant information, to start, would include. Product sold (prod), price of the product (p), quantity…

What is the minimum number of people a group must have to guarantee at least two people were born in the same month and on the same day of the week? 12 +7 (12 + 1) x (7 + 1) 12+7+1 (12+1)x7 12 x 7 12 x 7+1 12 x (7 + 1)

Suppose that you want to increase all three of the resource availabilities in the product mix model simultaneously by the same percentage. You want this percentage to vary from 225% to 50% in increments of 5%. Modify the spreadsheet model slightly so that this sensitivity analysis can be performed with a one- way SolverTable, using the percentage change as the single input. Keep track of the computers produced in row 21, the hours used in the range B26:B28, and the total profit. Discuss the results.

Lazy Eddie is a furniture chain specializing in recliners. Their management has asked you to review the large number of printed reports that are distributed to Lazy Eddie’s 35 store managers. Management is not sure that the managers actually read or use the reports, even though the store managers say they want them. Store visits have shown many of the reports end up stacked on top of filing cabinets, seemingly untouched. To determine if store managers really use the printed reports, management has asked you to create a procedure that requires users to review and justify their information needs. You could design a form that asks if the information still is required, and why. You could try to get users to decide if a report is worth the cost of producing it. How do you proceed?

I am trying to create a new table.   What am I doing wrong.   CREATE TABLE STATS ( DEATHS_PER_100000_PEOPLE BY_RACE_OR_ETHNICITY_THROUGH_MARCH_7_2021 INSERT INTO STATS VALUES ('BLACK OR AFRICAN AMERICAN', 178);

The following dataset is a historic record of 14 houses that were sold in a small town in BC. The dataset is used to predict whether a new house in the same town will be sold in 10 days if listed with a specific price based on certain attributes. We are considering only four attributes (price, number of bedrooms, size, and distance to bus stop) just to simplify the calculations in this assignment but more attributes should be considered in real applications. House Price Number of Bedrooms Size (sqft) Distance to Bus-Stop House sold in 10 days? House 1 $300,000 1 3,500 sqft far No House 2 $300,000 1 3,500 sqft near No House 3 $250,000 1 3,500 sqft far Yes House 4 $350,000 2 3,500 sqft far Yes House 5 $350,000 3 5,000 sqft far Yes House 6 $350,000 3 5,000 sqft near No House 7 $250,000 3 5,000 sqft near Yes House 8 $300,000 2 3,500 sqft far No House 9…

Consider these factors while determining the sentinel value you want to use.