Using MIS (10th Edition)
10th Edition
ISBN: 9780134606996
Author: David M. Kroenke, Randall J. Boyle
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Expert Solution & Answer
Chapter AE, Problem AE3.1
Explanation of Solution
a)
Make the first two rows of the spreadsheet similar to that in figure AE-1. Choose the background color and the type...
Explanation of Solution
b)
Place the current date which is centered in cells C3, D3 and E3 and merge all the specified cells...
Explanation of Solution
c)
Make the outline for the cells as shown in Figure AE-1.
Explanation of Solution
d)
Enter random data in the spreadsheet.
Use the formula as shown in figure AE-1...
Explanation of Solution
e)
Formatting the cells in the column.
Explanation of Solution
f)
Three management decision that can be inferred from the data,
The three management decisions that can be inferred from the table are,
- The bike models which occupies more inventory.
- The models occupying more inventories and the revenue generated by each models...
Explanation of Solution
g)
Other calculation which might helpful for the bike rental management:
- The additional calculation can be made to generate...
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Use Python Code
Your task is : Visualization of confirmed cases of COVID-19 by country . (Use pandas to read the data table csv. Example df = pd.read_csv('COVID19.csv' ) then make a visualization using that csv table)
Province/State
Country
Lat
Long
########
########
########
########
########
########
########
########
########
########
2/1/2020
2/2/2020
2/3/2020
2/4/2020
2/5/2020
2/6/2020
2/7/2020
2/8/2020
2/9/2020
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
3/1/2020
3/2/2020
3/3/2020
3/4/2020
3/5/2020
3/6/2020
3/7/2020
3/8/2020
3/9/2020
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
########
4/1/2020
4/2/2020
4/3/2020
4/4/2020
4/5/2020
4/6/2020
4/7/2020
Afghanistan
33
65
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0…
Create a matrix and manipulate the values inside.
Tables: 1. Brands (sample csv enclosed) a. Brand ID b. Brand Name c. Holding Company ID d. Holding Company Name 2. Store Order Items (sample csv enclosed) a. Order ID b. User ID c. Product ID d. Brand ID e. Unit Price f. Quantity g. Date (of sale) h. Store ID (of sale)
2. For each Product (ID), determine the “store of sale” that made the first sale of the product in 2019.
Written in Sql
Chapter AE Solutions
Using MIS (10th Edition)
Ch. AE - The spreadsheet in Microsoft Excel file...Ch. AE - Prob. AE1.2Ch. AE - Prob. AE2.1Ch. AE - Prob. AE2.2Ch. AE - Prob. AE3.1Ch. AE - In this exercise, you will learn how to create a...Ch. AE - Prob. AE4.1Ch. AE - Prob. AE4.2Ch. AE - In some cases, users want to use Access and Excel...Ch. AE - Prob. AE5.2
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Similar questions
- While the datamodel design process was still underway, an enterprising accountant started putting together data in a spreadsheet already. Tshepo applauded his enthusiasm, but he is worried about the integrity of the data, despite the fact that the accountant says his data is in first normal form already. Here is a sample of the spreadsheet data, in first normal form (underlined columns names indicate the composite primary key): Company Company Department Department Product Product Name ID Name ID ID Name VR1000 Product Product Type ID Type Name 1 Headset 1 1 ACME VR ACME VR ACME VR 1 1 1 0 No Product Date Value 3306/01/23 521 3306/01/24 -250 3306/01/23 105 3306/01/23 999 3306/01/23 50 1 Production Production HR Finance Production 2 0 No Product 2 ACME Movies 3 0 No Product MC9 2 ACME Movies 4 2 2 Cameraarrow_forwardDesign an adjacency Matrix of the alphabets of your full name. In accordance with the following conditions:arrow_forward2. Get the Groups As new students begin to arrive at college, each receives a unique ID number, 1 to n. Initially, the students do not know one another, and each has a different circle of friends. As the semester progresses, other groups of friends begin to form randomly. There will be three arrays, each aligned by an index. The first array will contain a queryType which will be either Friend or Total. The next two arrays, students1 and students2, will each contain a student ID. If the query type is Friend, the two students become friends. If the query type is Total, report the sum of the sizes of each group of friends for the two students.arrow_forward
- Given the following average precipitation data which contains both categorical and numerical data: data = [ ('city': 'Atlanta', 'precipitation in mm': '1263'}, ['city': 'Austin', 'precipitation in mm': '870'} ['city': 'Chicago', 'precipitation in mm': '937"} 3 Using one-hot encoding, what would be your feature matrix? Insert a table with column names to show your answer:arrow_forwardcomplete 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 cpparrow_forwardcomplete 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.arrow_forward
- 1) Create a histogram for Displacement with bin increments of 50. Paste the histogram with appropriately labeled title and axis. 2) Create a scatter plot showing the relationship between acceleration and horsepower. Paste the chart with appropriately labeled title and axis. 3) What is the correlation coefficient of horsepower and the cylinders the vehicles in the data set. Show the returned value of the correlation and describe the relationship.arrow_forwardUse the data file “marketing_campaign.csv” for this problem. Note: There are rows at the top of the file that must be skipped. a. Read the data into R and create a subset consisting of the following columns: Education, Marital_Status, Income, Dt_Customer, MntFruits, and Complain. b. Convert the data a type of the following columns: Education Ordered factor (Hint: Level of “2n Cycle” is between Graduation and Master Marital_Status Unordered factor Income Double precision numeric Complain Logical c. Convert the data type of Dt_Customer to Date. d. With proper code check the data types of columns are as stated in (b) and (c).arrow_forwardINSERT INTO Athletics VALUES((100, 'Samuel', 'David', '1967-11-17', '23',1967-11-20); INSERT INTO Athletics VALUES((110, 'Mario', 'Cassius', '1967-11-13', '22',1967-11-20 ); INSERT INTO Athletics VALUES((104, 'Mario', Ace', '1967-12-31', '26',1967-11-20 ); INSERT INTO Athletics VALUES((123, 'Cristisno', 'Ronny', '1965-11-13', '28',1967-11-20 ); INSERT INTO Athletics VALUES((110, 'Harx', 'Wale', '1964-11-12', '20',1967-11-20 ); QUESTION Create a stored procedure named sp_InsertAthleteDetails, which enters details into the Athletics table by using 4 parameters for the first four columns in the Athletics table. Set No Count on.arrow_forward
- The chr21_genes.txt file lists genes from human chromosome 21, in their order along the chromosome, as described in Hattori et al. (Nature 405, 311-319) (Links to an external site.). For each gene, the file gives the gene symbol, description and category. The fields are separated by tabs. You will need to get the the meaning of each category. You can find these meanings in the original paper (Links to an external site.), under the "Gene categories" section. Create a file named chr21_genes_categories.txt that store this information in tab separated fields:arrow_forwardNormalize the below table of data. Use a textual representation.arrow_forwardUse Python Code Your task is : Use pandas to read the csv table. Example df = pd.read_csv('COVID19.csv' ), then make a visualization of confirmed cases of COVID-19 by country using matplotlib, seaborn, etc. Just tell me how to do it ! Why this question always get rejected ?! Covid-19 Confirmed table (csv) : Province/State Country Lat Long ######## ######## ######## ######## ######## ######## ######## ######## ######## ######## 2/1/2020 2/2/2020 2/3/2020 2/4/2020 2/5/2020 2/6/2020 2/7/2020 2/8/2020 2/9/2020 ######## ######## ######## ######## ######## ######## ######## ######## ######## ######## ######## ######## ######## ######## ######## ######## ######## ######## ######## ######## 3/1/2020 3/2/2020 3/3/2020 3/4/2020 3/5/2020 3/6/2020 3/7/2020 3/8/2020 3/9/2020 ######## ######## ######## ######## ######## ######## ######## ######## ######## ######## ######## ######## ######## ######## ######## ######## ######## ######## ######## ######## ######## ######## 4/1/2020 4/2/2020 4/3/2020…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Np Ms Office 365/Excel 2016 I NtermedComputer ScienceISBN:9781337508841Author:CareyPublisher:Cengage
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage