Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

can I just have the process for how to do those questions? because the data is too big, i can not post all Refer to

image text in transcribed
image text in transcribed
can I just have the process for how to do those questions? because the data is too big, i can not post all
Refer to the worksheet named SOFTWARE. This worksheet provides information about 2000 software programs (rows 2-2001, each row is a different software program). Some rows are hidden to enable you to see the first and last rows easily. Column A contains an ID number for each software program. The remaining columns describe each program in terms of lines of code (total, not per procedure), number of users, and so on. 9 Considering all 2000 software programs in the data set (this refers to all 2000 rows, each row is a separate software program), what is the total number of lines of code? 10 How many of the programs (each row is a separate program) were developed during the year 2001? 11 What is the average number of users of programs written in Pascal? 12. Calculate and consider the lines-of-code-per-procedure (Lines-of-Code / Procedure). Across all programs in the data set, what is the range (difference between highest and lowest) of the calculated values for the lines-of-code-per-procedure? 13. Do any programs appear in the worksheet that were written in HTML during 1999, have 15 or more users, and have less than 10 procedures and at least 300 lines of code? If so, provide the ID numbers of programs that have these characteristics. D E F G Lines of Number of Number of Year Lines of Code Code Procedures Users Developed Per Procedure 731 5 15 1999 380 9 4 1998 718 27 2 2001 662 9 9 1998 313 10 3 1999 691 29 7 1997 849 24 18 1997 957 10 5 1997 922 29 17 1999 288 22 7 1997 B ID Program Number Language 2 1 Html 3 2 Pascal 4. 3 Html 5 4 Html 6 5 Cobol 7 Cobol 1998 1997 Fortran 1999 1998 Pascal 2000 1999 C++ 2001 2000 C++ 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Information System Audit How To Control The Digital Disruption

Authors: Philippe Peret

1st Edition

1032136162, 978-1032136165

More Books

Students also viewed these Accounting questions

Question

Explain risk management concepts

Answered: 1 week ago

Question

Illustrate the link between business

Answered: 1 week ago