{"id":15582,"date":"2022-07-26T03:32:53","date_gmt":"2022-07-26T03:32:53","guid":{"rendered":"https:\/\/www.booksofall.com\/?post_type=product&#038;p=15582"},"modified":"2022-07-26T03:32:53","modified_gmt":"2022-07-26T03:32:53","slug":"business-calculus-with-excel-may-and-bart","status":"publish","type":"product","link":"https:\/\/www.booksofall.com\/fr\/business-calculus-with-excel-may-and-bart\/","title":{"rendered":"Business Calculus with Excel (May and Bart)"},"content":{"rendered":"<p>This text is intended for a one semester calculus course for business students with the equivalent of a college algebra prerequisite. Rather than being a three-semester engineering calculus course that has been watered down to fit into one semester it is designed for the business students.<\/p>\n<h3>Linear Functions and Models<\/h3>\n<p>We will start this chapter with a review of <a href=\"https:\/\/www.cuemath.com\/calculus\/linear-functions\/\" target=\"_blank\" rel=\"noopener\">linear functions<\/a>. In business there are quite a few examples of linear equations. Examples include supply and demand functions. There are some standard concepts related to lines that we will review, including the slope.<\/p>\n<p>Following the conventions of <a href=\"https:\/\/www.business-standard.com\/about\/what-is-microeconomics\" target=\"_blank\" rel=\"noopener\">microeconomics<\/a>, we will often use the variables p and q, for price and quantity, rather than x and y. We will also follow the conventions of economics in treating quantity as the independent variable. (The q-axis will be the horizontal axis. A fast web search for supply demand equilibrium will convince you this standard usage.)<\/p>\n<h3>Equations of a line<\/h3>\n<p>From prior courses, such as college algebra, you will remember that lines can be written in several different forms. If we are given the slope and the -intercept, the <a href=\"https:\/\/www.cuemath.com\/geometry\/slope-intercept-form-of-a-line\/\" target=\"_blank\" rel=\"noopener\">slope intercept<\/a> form will be the equation of choice. If we are given a point and a slope, it might be faster if we use the point-slope form of a line.<\/p>\n<h3>Functions in the Business Setting<\/h3>\n<p>Not all functions we encounter in a business setting are linear. There are several other families of functions we should (re-) familiarize ourselves with. These models include:<\/p>\n<ul>\n<li><a href=\"http:\/\/dl.uncw.edu\/digilib\/Mathematics\/Algebra\/mat111hb\/PandR\/quadratic\/quadratic.html\" target=\"_blank\" rel=\"noopener\">Quadratic functions<\/a><\/li>\n<li><a href=\"https:\/\/mathinsight.org\/exponential_function\" target=\"_blank\" rel=\"noopener\">Exponential functions<\/a><\/li>\n<li>Logistic functions Normal distribution functions<\/li>\n<li><a href=\"https:\/\/medium.com\/all-math-before-college\/sinusoidal-functions-trigonometry-91d49128f9af\" target=\"_blank\" rel=\"noopener\">Sinusoidal functions<\/a><\/li>\n<\/ul>\n<h3>Quadratic Functions.<\/h3>\n<p>Quadratic functions should be very familiar from previous mathematics courses. They are of the form These are our standard parabolas.<\/p>\n<h3>Introduction to Excel Spreadsheets<\/h3>\n<p>This book will rely heavily upon the use of <a href=\"https:\/\/www.microsoft.com\/en-us\/microsoft-365\/excel\" target=\"_blank\" rel=\"noopener\">Excel<\/a>, since it is the standard mathematical tool used in the business world. (More precisely, the spreadsheet is the standard tool, and Excel is currently the de facto standard brand. Most of this text can easily be used with other spreadsheets.) However, we do not assume that the student has worked with Excel previously. Throughout the course we will introduce those features of Excel we need to do mathematics and model the business problems we encounter.<\/p>\n<p>While introducing Excel, we will also introduce rules of \u201cGood Excel practice.\u201d In a business environment, spreadsheets should be written so that someone else can easily understand the worksheet, and maintain it for future use. You should assume those same standards when submitting work in Excel.<\/p>\n<p>This section is meant as an introduction to several standard features of Excel we will use often. These include:<\/p>\n<ul>\n<li>Basic Arithmetic such as add, subtract, multiply etc.<\/li>\n<li>formulas: allows us to check if the formulas in the cells are what they should be.<\/li>\n<li>Quick fill: this feature takes a pattern and fills it across a column or a row. Relative and Absolute Reference: when do we refer to a fixed cell and when does the reference depend on our place in the spreadsheet?<\/li>\n<li>SUM(): Adding a large number of cells can be efficiently done with this feature.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p><iframe frameborder=\"0\" allowtransparency=\"true\" allowFullscreen=\"true\" style=\"width: 100%; height: 700px; border: none;\" src=\"https:\/\/online.visual-paradigm.com\/share\/book\/business-calculus-with-excel-may-and-bart--117hpzpjig?enforceShowPromotionBar=true&#038;p=1\"><\/iframe><\/p>\n","protected":false},"featured_media":15585,"template":"","meta":{"_yoast_wpseo_title":"","_yoast_wpseo_metadesc":"We will start this chapter with a review of linear functions. In business there are quite a few examples of linear equations. Examples include supply and demand functions."},"product_brand":[],"product_cat":[15,209],"product_tag":[],"class_list":{"0":"post-15582","1":"product","2":"type-product","3":"status-publish","4":"has-post-thumbnail","6":"product_cat-all","7":"product_cat-mathematics","9":"first","10":"instock","11":"shipping-taxable","12":"product-type-simple"},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.1.1 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Business Calculus with Excel (May and Bart) - BooksOfAll French<\/title>\n<meta name=\"description\" content=\"We will start this chapter with a review of linear functions. In business there are quite a few examples of linear equations. Examples include supply and demand functions.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.booksofall.com\/fr\/business-calculus-with-excel-may-and-bart\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Business Calculus with Excel (May and Bart) - BooksOfAll French\" \/>\n<meta property=\"og:description\" content=\"We will start this chapter with a review of linear functions. In business there are quite a few examples of linear equations. Examples include supply and demand functions.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.booksofall.com\/fr\/business-calculus-with-excel-may-and-bart\/\" \/>\n<meta property=\"og:site_name\" content=\"BooksOfAll French\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.booksofall.com\/fr\/wp-content\/uploads\/sites\/6\/2022\/07\/Business-Calculus-with-Excel-May-and-Bart-07.png\" \/><meta property=\"og:image\" content=\"https:\/\/www.booksofall.com\/fr\/wp-content\/uploads\/sites\/6\/2022\/07\/Business-Calculus-with-Excel-May-and-Bart-07.png\" \/>\n\t<meta property=\"og:image:width\" content=\"597\" \/>\n\t<meta property=\"og:image:height\" content=\"844\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:image\" content=\"https:\/\/www.booksofall.com\/fr\/wp-content\/uploads\/sites\/6\/2022\/07\/Business-Calculus-with-Excel-May-and-Bart-07.png\" \/>\n<meta name=\"twitter:label1\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data1\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.booksofall.com\/fr\/business-calculus-with-excel-may-and-bart\/\",\"url\":\"https:\/\/www.booksofall.com\/fr\/business-calculus-with-excel-may-and-bart\/\",\"name\":\"Business Calculus with Excel (May and Bart) - BooksOfAll French\",\"isPartOf\":{\"@id\":\"https:\/\/www.booksofall.com\/fr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.booksofall.com\/fr\/business-calculus-with-excel-may-and-bart\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.booksofall.com\/fr\/business-calculus-with-excel-may-and-bart\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.booksofall.com\/fr\/wp-content\/uploads\/sites\/6\/2022\/07\/Business-Calculus-with-Excel-May-and-Bart-07.png\",\"datePublished\":\"2022-07-26T03:32:53+00:00\",\"description\":\"We will start this chapter with a review of linear functions. In business there are quite a few examples of linear equations. Examples include supply and demand functions.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.booksofall.com\/fr\/business-calculus-with-excel-may-and-bart\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.booksofall.com\/fr\/business-calculus-with-excel-may-and-bart\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/www.booksofall.com\/fr\/business-calculus-with-excel-may-and-bart\/#primaryimage\",\"url\":\"https:\/\/www.booksofall.com\/fr\/wp-content\/uploads\/sites\/6\/2022\/07\/Business-Calculus-with-Excel-May-and-Bart-07.png\",\"contentUrl\":\"https:\/\/www.booksofall.com\/fr\/wp-content\/uploads\/sites\/6\/2022\/07\/Business-Calculus-with-Excel-May-and-Bart-07.png\",\"width\":\"597\",\"height\":\"844\",\"caption\":\"Business Calculus with Excel (May and Bart)\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.booksofall.com\/fr\/business-calculus-with-excel-may-and-bart\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.booksofall.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Categories\",\"item\":\"https:\/\/www.booksofall.com\/fr\/categories\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Business Calculus with Excel (May and Bart)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.booksofall.com\/fr\/#website\",\"url\":\"https:\/\/www.booksofall.com\/fr\/\",\"name\":\"BooksOfAll French\",\"description\":\"Biggest IT eBooks library and learning resources - Free eBooks for programming, computing, artificial intelligence and more.\",\"publisher\":{\"@id\":\"https:\/\/www.booksofall.com\/fr\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.booksofall.com\/fr\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.booksofall.com\/fr\/#organization\",\"name\":\"BooksOfAll French\",\"url\":\"https:\/\/www.booksofall.com\/fr\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/www.booksofall.com\/fr\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.booksofall.com\/fr\/wp-content\/uploads\/sites\/6\/2022\/06\/booksofall-logo-2.png\",\"contentUrl\":\"https:\/\/www.booksofall.com\/fr\/wp-content\/uploads\/sites\/6\/2022\/06\/booksofall-logo-2.png\",\"width\":166,\"height\":30,\"caption\":\"BooksOfAll French\"},\"image\":{\"@id\":\"https:\/\/www.booksofall.com\/fr\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Business Calculus with Excel (May and Bart) - BooksOfAll French","description":"We will start this chapter with a review of linear functions. In business there are quite a few examples of linear equations. Examples include supply and demand functions.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.booksofall.com\/fr\/business-calculus-with-excel-may-and-bart\/","og_locale":"fr_FR","og_type":"article","og_title":"Business Calculus with Excel (May and Bart) - BooksOfAll French","og_description":"We will start this chapter with a review of linear functions. In business there are quite a few examples of linear equations. Examples include supply and demand functions.","og_url":"https:\/\/www.booksofall.com\/fr\/business-calculus-with-excel-may-and-bart\/","og_site_name":"BooksOfAll French","og_image":[{"url":"https:\/\/www.booksofall.com\/fr\/wp-content\/uploads\/sites\/6\/2022\/07\/Business-Calculus-with-Excel-May-and-Bart-07.png","type":"","width":"","height":""},{"width":597,"height":844,"url":"https:\/\/www.booksofall.com\/fr\/wp-content\/uploads\/sites\/6\/2022\/07\/Business-Calculus-with-Excel-May-and-Bart-07.png","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_image":"https:\/\/www.booksofall.com\/fr\/wp-content\/uploads\/sites\/6\/2022\/07\/Business-Calculus-with-Excel-May-and-Bart-07.png","twitter_misc":{"Dur\u00e9e de lecture estim\u00e9e":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.booksofall.com\/fr\/business-calculus-with-excel-may-and-bart\/","url":"https:\/\/www.booksofall.com\/fr\/business-calculus-with-excel-may-and-bart\/","name":"Business Calculus with Excel (May and Bart) - BooksOfAll French","isPartOf":{"@id":"https:\/\/www.booksofall.com\/fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.booksofall.com\/fr\/business-calculus-with-excel-may-and-bart\/#primaryimage"},"image":{"@id":"https:\/\/www.booksofall.com\/fr\/business-calculus-with-excel-may-and-bart\/#primaryimage"},"thumbnailUrl":"https:\/\/www.booksofall.com\/fr\/wp-content\/uploads\/sites\/6\/2022\/07\/Business-Calculus-with-Excel-May-and-Bart-07.png","datePublished":"2022-07-26T03:32:53+00:00","description":"We will start this chapter with a review of linear functions. In business there are quite a few examples of linear equations. Examples include supply and demand functions.","breadcrumb":{"@id":"https:\/\/www.booksofall.com\/fr\/business-calculus-with-excel-may-and-bart\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.booksofall.com\/fr\/business-calculus-with-excel-may-and-bart\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/www.booksofall.com\/fr\/business-calculus-with-excel-may-and-bart\/#primaryimage","url":"https:\/\/www.booksofall.com\/fr\/wp-content\/uploads\/sites\/6\/2022\/07\/Business-Calculus-with-Excel-May-and-Bart-07.png","contentUrl":"https:\/\/www.booksofall.com\/fr\/wp-content\/uploads\/sites\/6\/2022\/07\/Business-Calculus-with-Excel-May-and-Bart-07.png","width":"597","height":"844","caption":"Business Calculus with Excel (May and Bart)"},{"@type":"BreadcrumbList","@id":"https:\/\/www.booksofall.com\/fr\/business-calculus-with-excel-may-and-bart\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.booksofall.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Categories","item":"https:\/\/www.booksofall.com\/fr\/categories\/"},{"@type":"ListItem","position":3,"name":"Business Calculus with Excel (May and Bart)"}]},{"@type":"WebSite","@id":"https:\/\/www.booksofall.com\/fr\/#website","url":"https:\/\/www.booksofall.com\/fr\/","name":"BooksOfAll French","description":"Biggest IT eBooks library and learning resources - Free eBooks for programming, computing, artificial intelligence and more.","publisher":{"@id":"https:\/\/www.booksofall.com\/fr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.booksofall.com\/fr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Organization","@id":"https:\/\/www.booksofall.com\/fr\/#organization","name":"BooksOfAll French","url":"https:\/\/www.booksofall.com\/fr\/","logo":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/www.booksofall.com\/fr\/#\/schema\/logo\/image\/","url":"https:\/\/www.booksofall.com\/fr\/wp-content\/uploads\/sites\/6\/2022\/06\/booksofall-logo-2.png","contentUrl":"https:\/\/www.booksofall.com\/fr\/wp-content\/uploads\/sites\/6\/2022\/06\/booksofall-logo-2.png","width":166,"height":30,"caption":"BooksOfAll French"},"image":{"@id":"https:\/\/www.booksofall.com\/fr\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/www.booksofall.com\/fr\/wp-json\/wp\/v2\/product\/15582","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.booksofall.com\/fr\/wp-json\/wp\/v2\/product"}],"about":[{"href":"https:\/\/www.booksofall.com\/fr\/wp-json\/wp\/v2\/types\/product"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.booksofall.com\/fr\/wp-json\/wp\/v2\/media\/15585"}],"wp:attachment":[{"href":"https:\/\/www.booksofall.com\/fr\/wp-json\/wp\/v2\/media?parent=15582"}],"wp:term":[{"taxonomy":"product_brand","embeddable":true,"href":"https:\/\/www.booksofall.com\/fr\/wp-json\/wp\/v2\/product_brand?post=15582"},{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/www.booksofall.com\/fr\/wp-json\/wp\/v2\/product_cat?post=15582"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/www.booksofall.com\/fr\/wp-json\/wp\/v2\/product_tag?post=15582"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}