图书简介
This book serves as a comprehensive step-by-step guide on data analysis and statistical analysis. It covers fundamental operations in Excel, such as table components, formula bar, and ribbon, and introduces visualization techniques and PDE derivation using Excel. It also provides an overview of Google Colab, including code and text cells, and explores visualization and deep learning applications.Key features of the book include topics like statistical analysis, regression analysis, optimization, correlation analysis, and neural networks. It adopts a practical approach by providing examples and step-by-step instructions for learners to apply the techniques to real-world problems.The book also highlights the strengths and features of both Excel and Google Colab, allowing learners to leverage the capabilities of each platform. The clear explanations of concepts, visual aids, and code snippets aid comprehension help learners understand the principles of data analysis and statistical analysis. Overall, this book serves as a valuable resource for professionals, researchers, and students seeking to develop skills in data analysis, regression statistics, optimization, and advanced modeling techniques using Excel, Colab, and neural networks.Key FeaturesComprehensive Coverage: The book offers a comprehensive coverage of Excel regression statistics, statistical analysis, What-if analysis, Solver, Colab, neural networks (NNs), and advanced applications. It encompasses a wide range of topics related to data analysis and modelingPractical Approach: The book emphasizes practical application by providing step-by-step instructions and examples. Readers can learn how to perform various statistical analyses, implement regression analysis, optimization, and neural networks using Excel and Google ColabNeural Network Implementation: Readers can understand how neural networks work without programming. Using the Excel macros in the appendix, readers can build a neural network with a given number of layers and number of neurons per layer on an Excel sheet and calculate the parameters using the Excel solverIntegration of Automatic Differentiation: The book introduces the concept of automatic differentiation in neural networks and demonstrates its application in regression equations and visualization. This unique aspect enhances the accuracy and efficiency of data analysisPDE Derivation and Solutions: It explores the derivation of partial differential equations (PDEs) describing physical data and provides methods for solving them, including Fourier transform and physics-informed neural networks (PINNs). This coverage sets it apart from other books and caters to readers interested in advanced mathematical modelingPhysically Based Surrogate Model: The book introduces the concept of a physically based surrogate model, particularly the CAE (Computer-Aided Engineering) surrogate model. It showcases its application in carbon neutrality and highlights the value of physics-based learningHands-on Examples and Applications: Throughout the book, readers will find practical examples and application cases, enabling them to grasp the concepts effectively and apply them to real-world scenariosCompetitive Advantage: The book stands out with its unique combination of Excel, Google Colab, and neural networks for data analysis and modeling. It provides a competitive advantage over other books by offering comprehensive coverage, practical techniques, and advanced applicationsValue-added Features: The inclusion of detailed explanations, visualizations, implementation techniques (including Excel macros and VBA), and application examples enriches the learning experience and helps readers develop practical skills
Introduction: Basic Operations of Excel; Basic Operations of Google Colab (Colab); Organization of This Document; Basic: Background; Statistical Analysis in Excel; Regression Analysis; What-if Analysis; Solver; Colab; NNs; Practical Part: About PINNs; Automatic Differentiation in NN; Using Automatic Differentiation in Regression Equation; Automatic Differentiation using Colab; Increasing the Accuracy of Visualization of Magnetic Line Group Data using Automatic Differentiation; Generation of a CAD Model from Point Cloud Data using Point Cloud Data Processing Software; Advanced Application Section: Derivation of PDEs Describing Physical Data; Use of Visual Analysis Techniques; Methods for Solving a Given PDE; Physically Based Surrogate Model: About the CAE Surrogate Model; Application to Carbon Neutrality (CN); Closing Remark
Trade Policy 买家须知
- 关于产品:
- ● 正版保障:本网站隶属于中国国际图书贸易集团公司,确保所有图书都是100%正版。
- ● 环保纸张:进口图书大多使用的都是环保轻型张,颜色偏黄,重量比较轻。
- ● 毛边版:即书翻页的地方,故意做成了参差不齐的样子,一般为精装版,更具收藏价值。
关于退换货:
- 由于预订产品的特殊性,采购订单正式发订后,买方不得无故取消全部或部分产品的订购。
- 由于进口图书的特殊性,发生以下情况的,请直接拒收货物,由快递返回:
- ● 外包装破损/发错货/少发货/图书外观破损/图书配件不全(例如:光盘等)
并请在工作日通过电话400-008-1110联系我们。
- 签收后,如发生以下情况,请在签收后的5个工作日内联系客服办理退换货:
- ● 缺页/错页/错印/脱线
关于发货时间:
- 一般情况下:
- ●【现货】 下单后48小时内由北京(库房)发出快递。
- ●【预订】【预售】下单后国外发货,到货时间预计5-8周左右,店铺默认中通快递,如需顺丰快递邮费到付。
- ● 需要开具发票的客户,发货时间可能在上述基础上再延后1-2个工作日(紧急发票需求,请联系010-68433105/3213);
- ● 如遇其他特殊原因,对发货时间有影响的,我们会第一时间在网站公告,敬请留意。
关于到货时间:
- 由于进口图书入境入库后,都是委托第三方快递发货,所以我们只能保证在规定时间内发出,但无法为您保证确切的到货时间。
- ● 主要城市一般2-4天
- ● 偏远地区一般4-7天
关于接听咨询电话的时间:
- 010-68433105/3213正常接听咨询电话的时间为:周一至周五上午8:30~下午5:00,周六、日及法定节假日休息,将无法接听来电,敬请谅解。
- 其它时间您也可以通过邮件联系我们:customer@readgo.cn,工作日会优先处理。
关于快递:
- ● 已付款订单:主要由中通、宅急送负责派送,订单进度查询请拨打010-68433105/3213。
本书暂无推荐
本书暂无推荐