Use a single excel file with formulas within answer cells. Show formulas in Excel  Your retail business sells pumpkins. You have to decide how many pumpkins to order from the farmer.  Based on your historical sales, you think the probability of selling 500 is 0.2, 1000 is 0.35, 1500 is 0.35, and 2000 is 0.1.  You can buy each pumpkin from the farmer for $3.35 and sell each pumpkin for $5.00.  If you have leftover pumpkins at the end of the season, you can sell them to a local homeless shelter for $1.75. Calculate all EMVs and recommend a strategy.

2. In the attached file, you will find the oil production for all countries that produce more than 1Mbpd, use pie chart and bar chart to show the percentage of production for each of them. Canada 4656000 4260000 country bpd Iraq China United States 11567000 3969000 Russia 10503000 United Ara 2954000 2852000 2610000 2546000 Kazakhstan 1937000 1744000 Saudi Arabia 10225000 Brazil Canada 4656000 Kuwait Iraq 4260000 Iran China 3969000 United Arab Norway Mexico Emirates 2954000 1733000 Brazil 2852000 Qatar 1297000 Kuwait 2610000 1258000 1220000 1158000 Nigeria Iran 2546000 Libya Angola Kazakhstan 1937000 Norway 1744000 Мехico 1733000 Qatar 1297000 Nigeria 1258000 Libya Angola 1220000 1158000 USING MAT LABEL PROGRAM Unted States Mexico Nonway 10 Kazakhatan van Kuwat Rusia Bras 3d Arat Emirates China Saud Arabia rag Canada

complete the data system for citywide taxi company. now, the information for each taxi is expanded to include: taxi id (such as ctc0001), the driver’s name, the maker of the car (such as ford), the model of the car (such as escape), the color of the car (such as black), the license number (such as hxt 4578), the number of passages the car served in the entire shift (integer type, this field will be left empty for this project). your c++ program will (with array of class object): define a class for the car with all members of variable mentioned above as private;  write all necessary class member functions to access those member variables (write or read); ) read up to 50 records of data from the keyboard (provide a method to end the input before reaching 50 records); save all records inputted from step 3 to a disk file called ctc.dat.

complete the data system for citywide taxi company. now, the information for each taxi is expanded to include: taxi id (such as ctc0001), the driver’s name, the maker of the car (such as ford), the model of the car (such as escape), the color of the car (such as black), the license number (such as hxt 4578), the number of passages the car served in the entire shift (integer type, this field will be left empty for this project). your c++ program will (with array of class object): define a class for the car with all members of variable mentioned above as private;  write all necessary class member functions to access those member variables (write or read); read up to 50 records of data from the keyboard (provide a method to end the input before reaching 50 records); (1 points) save all records inputted from step 3 to a disk file called ctc.dat.  In cpp

According to your student number and the following formula, please answer the corresponding questions in one single file. student number:170201034 if(yourStudentNumer % 3==0)                   select questions with X[0] lable   if(yourStudentNumer % 3==1)                   select questions with X[1] lable   if(yourStudentNumer % 3==2)                   select questions with X[2] lable

On the Faculty Data worksheet, in cell J3, use an IFS function to calculate the retirement matching dollar amount for each faculty member participating in the retirement plan. If the participating member is a Full Professor, the matching amount is 4% of the salary. Otherwise, the matching amount is 3% of the salary. If the member is not participating, show a blank.

A6. Suppose a farmer decided to keep individual records for the new cattle. His records show 4 bred heifers valued at $900; 5 cows valued at $1,000, and 1 bull valued at $2,000. Using the chart below, setup the individual records for each animal for year 1. Make sure that your animal ID for each type of animal is different, for example, bred heifers can start at 22-1, etc.; cows can start at 22- 01, and the bull can be 22-001.

Copied answer will be downvoted

1. List all vehicles and their average number of rental days per year. The results should be displayed as Year, RegNo, make, model, average number of days.   2. Count the number of cars rented in each quarter of each year. your output should show rental year, wuarter, number of cars rented. Quarter 1 contains months Jan, Feb, March; quarter 2 - April, May, June, etc. Note, year 2022 has records for quarter 1 only.   Using the SQL syntax   Here is the physical model of this database.

The population of the five most populous Australian cities at the last three census is recorded in the following cell. Piot a side- by-side bar chart to show the change in the populations, The chart should be grouped by each city and show each census in different colours. The legend should explain the colours for the census. Your plot should include an appropriate title. In [ J: cities - ['sydney', Melbourne', 'Brisbane', Perth', 'Adelaide') Pop_2016 - (4321535,4196198,2054614,1874578,11656321 Pop_2011 - [3908642,3707530,1874427,1627576,11039791 Pop_2006 - [3641422,3371888,1676389,1256035,10407191 In [ ]: