EBK USING MIS
10th Edition
ISBN: 9780134658919
Author: KROENKE
Publisher: YUZU
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 solution
Students have asked these similar questions
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 [ ]:
Create a matrix and manipulate the values inside.
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
Camera
Chapter AE Solutions
EBK USING MIS
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
- 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 Sqlarrow_forwardGiven 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_forwardDesign an adjacency Matrix of the alphabets of your full name. In accordance with the following conditions:arrow_forward
- 2. 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_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_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_forwardThe 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_forward
- Use 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_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_forwardC sharp Table: Student (the headers are the field names in the Students table) StudentID Name Age Gender ProgramID 791 Stephanie Brown 19 Female BCS 236 Shannon Dawn 25 Female BA 618 Geoff Berg 24 Male ARET 256 Andrew Schilling 22 Male BSC 902 Gary Sang 23 Male DAAD Note: There is a StudentDataSet with a Student table, a StudentTableAdapter, a StudentBindingSource, and a StudentDataGridView control on the form.Note: There is an Average query, named Average, that returns the average age of the student from the Student table.Note: There is also Max query, named Highest, that returns the highest age of the student from the Student table.Write the code you would place in the AverageButton click event on your form to call the Average query and the Highest query and display in a DifferenceLabel, the difference between the highest age of a student and the average age.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